Am 13.01.2011 17:36, schrieb Larry H.:

> STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;
> 
> Does this not necessarily mean that my databases are in sync? Also what do
> you use for packet logging? 

Not really
You should init the slave with identical state

* stop the master
* delete all binlog files
* make a backup of the datadir
* start the master (it writes all changes to the new binlog)
* stop the salve
* replace the datadir
* start replication

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to