Hi.
On Mon 2002-08-19 at 17:29:49 +0200, [EMAIL PROTECTED] wrote:
> Hi, folks!
>
> I would apreciate your opinion on my question:
> How to make a MyISAM table (or several tables) to be shared among different
> databases served by one MySQL server on Unix (Solaris)? It is OK if this table
> appears as a read/write table in one database only, other DBs access it
> read-only.
>
> My experience with tables, being hardlinked to the different directories (i.e.
> databases), is bad, as these tables soon become corrupted. However, I did not
> experiment with softlinks (ln -s).
>
> Any ideas?
I think there is no reasonable way to do this. But what is your reason
to try this?
Usually I would put the common table within its own database and
simply use this database in queries, like this:
SELECT * FROM table1 as one, common.table2 as two WHERE one.whatever = two.whatever
If that does not fit your case, please elaborate.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
