I also discovered that LOAD DATA FROM MASTER doesn't work, however, LOAD TABLE tbl_name FROM MASTER does work.
Alex Wheeler -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christian G. Warden Sent: Wednesday, April 28, 2004 12:19 PM To: DBMail mailinglist Subject: Re: SV: SV: [Dbmail] mirroring dbmail mySQL database On Wed, Apr 28, 2004 at 11:32:23AM +0200, Jocke wrote: > If you want to set it all up, just make sure you start an update-log on your > master server and connect the slave to it.. then if you're running mysql 4.0 > or higher just issue the command "LOAD DATA FROM MASTER;" and the slave will > become up-to-date. After that it will continue to read the updatelog and > manage on its own. "LOAD DATA FROM MASTER" doesn't work with InnoDB. Since he's using two different table handlers, mysqldump is probably the best way to bring the slave up to date. Has anyone looked into using MySQL Cluster? Information on NDB is scarce on mysql.com. xn _______________________________________________ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail