Benjamin, thanks for the answer! There are at least two reasons to have such a common table shared between databases, and having it explicitly appear as a regular table in each of the DBs: 1. to make such a table accessible for users, which suppose to "live" entirely in their DBs. 2. to make such a table visible for DBA tools, which cannot jump from one DB to another.
Best, Dmitry ----- Original Message ----- From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Dmitry Kuznetsov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 8:03 PM Subject: Re: How to share a MyISAM table among different databases > 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 > > --------------------------------------------------------------------- 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