mysql backup validation
The only way you can validate a backup is to restore that backup; plain and simple. Spin up a VM, install the same version of MySQL from which you took the backup, restore the backup and run some simple tests. If you make this new VM a slave of the original master, configure replication and use pt-table-checksum to validate all data is the same on the slave. At the very least you can use CHECKSUM TABLE &lt;table&gt;; on every table in every database to validate that MySQL is capable of reading every row.