MySQL Forums :: InnoDB :: Master-Slave with InnoDB

I would say firstly try using mk-table-checksum to see the difference between master and slave databases if the differences are not high then try mk-table-sync utility

http://www.maatkit.org/doc/mk-table-checksum.html
http://www.maatkit.org/doc/mk-table-sync.html

If you find alot of discrepancy then take online backup (it won't block write/read operations) using mysqldump with following switches

mysqldump --single-transaction --master-data=2 -A > all_databases.sql

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_single-transaction

Since your database is quite large then the db restore would take significantly longer to complete in this case use MySQL Enteripse backup tool that is a very efficient

http://www.mysql.com/trials/



Edited 2 time(s). Last edit at 07/28/2011 10:00AM by Aftab Khan.