using (hard?) links for tables

2003-12-11 Thread Moritz von Schweinitz
hi there! i have two databases on the same server, and one of the tables ('users') should be the same in both databases. since this is very specific to this one server, and other servers running similar databases don't need that functionality, i'm looking for the easiest way to do this, so i

Re: using (hard?) links for tables

2003-12-11 Thread Moritz von Schweinitz
It's not recommended since it might cause file locking issues internally. how 'maybe' would that be? (that table almost never get written to, but when it is written to, the other one should be updated AFAP. both tables would almost never be written to at the same time) Why not just set up a

RE: using (hard?) links for tables

2003-12-11 Thread Dan Greene
... -Original Message- From: Moritz von Schweinitz [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 9:26 AM To: [EMAIL PROTECTED] Subject: using (hard?) links for tables hi there! i have two databases on the same server, and one of the tables ('users') should

Re: using (hard?) links for tables

2003-12-11 Thread Stephen Brownlow
] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, December 12, 2003 4:54 AM Subject: RE: using (hard?) links for tables What if you were to make a 3rd database, containing shared elements, such as your user table (I presume we're not talking the MySQL system user table) and then have