At the master:<\/p>\n
RESET MASTER;
\nFLUSH TABLES WITH READ LOCK;
\nSHOW MASTER STATUS;<\/p>\n
And copy the values of the result of the last command somewhere.<\/p>\n
Wihtout closing the connection to the client (because it would release the read lock) issue the command to get a dump of the master:<\/p>\n
mysqldump -uroot -p –all-database > \/a\/path\/mysqldump.sql<\/p>\n
Now you can release the lock, even if the dump hasn’t end. To do it perform the following command in the mysql client:<\/p>\n
UNLOCK TABLES;<\/p>\n
Now copy the dump file to the slave using scp or your preferred tool.<\/p>\n
At the slave:<\/p>\n
Open a connection to mysql and type:<\/p>\n
STOP SLAVE;<\/p>\n
Load master’s data dump with this console command:<\/p>\n
mysql -uroot -p < mysqldump.sql<\/p>\n
Sync slave and master logs:<\/p>\n
RESET SLAVE;
\nCHANGE MASTER TO MASTER_LOG_FILE=’mysql-bin.000001′, MASTER_LOG_POS=98;<\/p>\n
Where the values of the above fields are the ones you got from the folllowing:<\/p>\n
zcat dumpfile.sql.gz | head \u221230 | grep -i change<\/p>\n
Finally type<\/p>\n
START SLAVE;<\/p>\n
And to check that everything is working again, if you type<\/p>\n
SHOW SLAVE STATUS;<\/p>\n","protected":false},"excerpt":{"rendered":"
At the master: RESET MASTER; FLUSH TABLES WITH READ LOCK; SHOW MASTER STATUS; And copy the values of the result of the last command somewhere. Wihtout closing the connection to the client (because it would release the read lock) issue … Continue reading