RE: Mirroring a table

2003-03-27 Thread Don Read
On 27-Mar-2003 Ville Mattila wrote: > Hello everyone, > > I was wondering how could I make a mirror copy of a table to another > server > in the easiest way? I browsed through the MySQL documentation but didn't > find any clue of a "COPY TABLE" command or a similar method. I know that > I > can m

RE: Mirroring a table

2003-03-27 Thread Andrew Braithwaite
h_good_permissions dbname tablename | mysql dbnameof_the_otherserver" which effectively overwrites that table with the latest table.. Cheers, Andrew -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday 27 March 2003 21:44 To: 'Ville Mattila'; MySQL Mai

RE: Mirroring a table

2003-03-27 Thread Victor Pendleton
Is creating a cronjob a feasible alternative? -Original Message- From: Ville Mattila [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:50 PM To: MySQL Mailing List Subject: Mirroring a table Hello everyone, I was wondering how could I make a mirror copy of a table to another

Re: Mirroring a table

2003-03-27 Thread gerald_clark
Read about replication in the manual. This may be what you need. Ville Mattila wrote: Hello everyone, I was wondering how could I make a mirror copy of a table to another server in the easiest way? I browsed through the MySQL documentation but didn't find any clue of a "COPY TABLE" command or a s

Mirroring a table

2003-03-27 Thread Ville Mattila
Hello everyone, I was wondering how could I make a mirror copy of a table to another server in the easiest way? I browsed through the MySQL documentation but didn't find any clue of a "COPY TABLE" command or a similar method. I know that I can make a dump from a table and then run that dump file i