Hi Egor, Thanks for the reply. My responses below -
"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. --- Now why didn't I think of this! > 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? --- The slave got an error running an insert into a 4 field table with a primary key set on a column 'userid'. The slave SQL thread apparently stopped and the slave IO thread continued running, but the table stopped getting updated. The table type again was HEAP. Tx, Vinod. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
