Tuesday, November 25, 2008

Fixing the mysql server replication after it's gone out of sync:

on master: flush tables with read lock

Copy master to slave by (on slave, innodb requires this):

mysqldump --all --extended-insert | mysql

Then, on slave

RESET SLAVE
mysql> change master to MASTER_LOG_FILE='quetzal-bin.000076', MASTER_LOG_POS=34627216;


No comments: