Hello Baron, 2007/7/17, Baron Schwartz <[EMAIL PROTECTED]>:
Are you sure the master and slave had the same data at the time you started the slave replicating from the master? It looks to me like the slave had different data and you need to re-initialize the slave.
I'm not so sure.The order I made is: in master: flush tables with read lock; show master status; shutdown master mysqld. tar master db files. start master mysqld. in slave: shutdown slave mysqld. untar master db files into right directory. start slave mysqld. change master to ... start slave.
You may be able to use mysql-table-checksum and mysql-table-sync to synchronize the slave with the master without completely re-snapshotting it from the master, if that is an issue. (http://mysqltoolkit.sourceforge.net)
Thank you for the good info.would go to try it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
