MySQL Forums
Forum List  »  Backup

Re: Verifying Integrity of Databases
Posted by: Peter Brawley
Date: August 04, 2020 12:25PM

"...table file copying methods do not work if your database contains InnoDB tables. Also, even if the server is not actively updating data, InnoDB may still have modified data cached in memory and not flushed to disk." -- https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html

The only sure way to verify that a MySQL file copy restore process has been error-free is (i) monitor for errors, and if there were no such errors then (ii) regression-test all restored database functionality.

Options: ReplyQuote


Subject
Views
Written By
Posted
344
August 04, 2020 10:10AM
Re: Verifying Integrity of Databases
199
August 04, 2020 12:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.