Not the answer you need?
Register and ask your own question!

How to validate a backup

zafranchizafranchi EntrantCurrent User Role Beginner
Dear all,

During a scheduled backup procedure, how can I be sure that a backup is correct?
I used to work with Oracle Databases. With Oracle, we used to check size of files to determine the backup is valid or not. If the size of backup files were smaller than the actual size, we found out that we should run the backup procedure again.
As I know so far, the best solution for this issue is restoring the whole backup and running 'table checks' but restoring and checking tables take a lot of time. Is there any other solution to solve this problem without restoring?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.