Re: Verifying Integrity of Databases
"...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.
Subject
Views
Written By
Posted
879
August 04, 2020 10:10AM
Re: Verifying Integrity of Databases
615
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.