Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Proper way to re-sync

From: Jesse <jlc(at)msdlg.com>
Date: Sat Sep 29 2007 - 07:54:03 EDT


When the databases get out of sync during replication, what is the best way to re-sync them on a Windows system? The only way I know of right now is to do it late at night, and pray that no one gets in while you're doing it. Stop the slave, do a backup (using MySQL Administrator, or mysqldump), note the log position on the master, restore the data on the slave, change the log position on the slave, then re-start the slave. Is this the best way to do it?

My issue has always been that I need the master MySQL running all the time. I might be able to stop it for a minute or two, and I'm sure that'll generate errors, but what can I do. But, in order to run a backup, it needs to be running. I've tried the "copy the physical files" thing, and that has never worked for me. Don't know why, but it doesn't.

Any ideas?

Thanks,
Jesse

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com
Received on Sat Sep 29 07:55:51 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:14:24 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library