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
y, August 20, 2002 3:19 PM Subject: Re: How to share a MyISAM table among different databases > 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. > >

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
ust 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 (

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

How to share a MyISAM table among different databases

2002-08-19 Thread Dmitry Kuznetsov
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.