Re: How to share a MyISAM table among different databases

2002-08-20 Thread Benjamin Pflugmann
Hi. On Tue 2002-08-20 at 10:58:53 +0200, [EMAIL PROTECTED] wrote: > > 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

Re: How to share a MyISAM table among different databases

2002-08-20 Thread Dmitry Kuznetsov
prefix is the only choice... Thanks again, Dmitry. - Original Message - From: "Tod Harter" <[EMAIL PROTECTED]> To: "Sergei Golubchik" <[EMAIL PROTECTED]>; "Dmitry Kuznetsov" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesda

RE: How to share a MyISAM table among different databases

2002-08-20 Thread Luc Foisy
mann > Cc: [EMAIL PROTECTED] > Subject: Re: How to share a MyISAM table among different databases > > > 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 re

Re: How to share a MyISAM table among different databases

2002-08-20 Thread Tod Harter
On Tuesday 20 August 2002 06:27 am, Sergei Golubchik wrote: The key quote from the manual is... All used tables must be in the same database as the MERGE table itself. which makes sense. Fundamentally a database is an independent unit of data storage. You can't share data between two seperate

Re: How to share a MyISAM table among different databases

2002-08-20 Thread Sergei Golubchik
Hi! On Aug 20, Dmitry Kuznetsov wrote: > 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

Re: How to share a MyISAM table among different databases

2002-08-20 Thread Dmitry Kuznetsov
t;[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

Re: How to share a MyISAM table among different databases

2002-08-20 Thread Dmitry Kuznetsov
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, Aug

Re: How to share a MyISAM table among different databases

2002-08-19 Thread Sergei Golubchik
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 MySQ

Re: How to share a MyISAM table among different databases

2002-08-19 Thread Benjamin Pflugmann
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 > appea