Hi, Sergey! As stated in description: "A MERGE table is a collection of identical MyISAM tables that can be used as one. ", i.e. content of these tables, being merged, is merged also. I need the opposite - one physical table being represented in multiple DBs as if these replicas are regular tables.
Although, one may have one master table (with master contents), and empty tables with the same structure in other DBs. Such an empty table might be merged over the master table. Yes. Thanks for the hint! Dmitry. ----- Original Message ----- From: "Sergei Golubchik" <[EMAIL PROTECTED]> To: "Benjamin Pflugmann" <[EMAIL PROTECTED]>; "Dmitry Kuznetsov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 19, 2002 8:36 PM Subject: Re: How to share a MyISAM table among different databases > Hi! > > On Aug 19, Benjamin Pflugmann wrote: > > 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. > > > > > > Any ideas? > > > > I think there is no reasonable way to do this. But what is your reason > > to try this? > > Benjamin, it is possible with MERGE tables. > And as MERGE tables support INSERTs ;)) > may be this aliasing can even work with read/write access. > > One can edit .MRG file to add a proper path there. > > Regards, > Sergei > > -- > MySQL Development Team > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ > /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany > <___/ > > --------------------------------------------------------------------- > 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
