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:
Post a Comment