"Vinod Panicker" <[EMAIL PROTECTED]> wrote: > Hi, > > Had a query regarding replication with HEAP tables. It seems like I cannot > use LOAD DATA FROM MASTER to update the stopped slave with data from the > master since it apparently works only for MyISAM tables. Any other way of > updating the slave with a snapshot of the data? Since a HEAP table doesn't > create a disk file, I cant get a snapshot using tar.
You can use mysqldump utility on your master and then run SQL script on the slave. > Also, the slave stopped due to an error of a duplicate key! Why should it > have a problem with inserting data that went through fine on the master? Could you describe your problem more detailed? What is the table type? Did it happen with HEAP table? What is the failed query? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
