Documentation Home
MySQL Enterprise Backup 8.0 User's Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb
HTML Download (TGZ) - 187.2Kb
HTML Download (Zip) - 217.4Kb


4.2.2 Verifying a Backup

You can check the integrity of your backup using the validate command. The following is a sample command for validating a backup image and the output for the successful validation:

$ mysql-commercial-8.0.11$ bin/mysqlbackup --backup-image=/home/mysqlbackup/backups/my.mbi validate
MySQL Enterprise Backup version 8.0.11 Linux-3.8.13-68.3.4.el6uek.x86_64-x86_64 [2018-03-15  14:13:10] 
Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved.

180322 21:36:59 MAIN    INFO: A thread created with Id '140541810280256' 
180322 21:36:59 MAIN    INFO: Starting with following command line ...
 bin/mysqlbackup --backup-image=/home/mysqlbackup/backups/my.mbi validate 

180322 21:36:59 MAIN    INFO: 
IMPORTANT: Please check that mysqlbackup run completes successfully.
           At the end of a successful 'validate' run mysqlbackup
           prints "mysqlbackup completed OK!".

180322 21:36:59 MAIN    INFO: Backup Image MEB version string: 8.0.11 [2018-03-15  14:13:10]
180322 21:36:59 MAIN    INFO: MySQL server version is '8.0.11'
180322 21:36:59 MAIN    INFO: TDE Keyring service initialized.
180322 21:36:59 MAIN    INFO: Creating 14 buffers each of size 16777216.
180322 21:36:59 MAIN    INFO: Validate operation starts with following threads
		1 read-threads    6 process-threads
180322 21:36:59 MAIN    INFO: Validating image ... /home/mysqlbackup/backups/my.mbi
180322 21:36:59 RDR1    INFO: A thread created with Id '140541539923712' 
180322 21:36:59 PCR2    INFO: A thread created with Id '140541523138304' 
180322 21:36:59 PCR1    INFO: A thread created with Id '140541531531008' 
180322 21:36:59 PCR5    INFO: A thread created with Id '140541506352896' 
180322 21:36:59 PCR6    INFO: A thread created with Id '140541497960192' 
180322 21:36:59 PCR4    INFO: A thread created with Id '140541396252416' 
180322 21:36:59 PCR3    INFO: A thread created with Id '140541514745600' 
180322 21:36:59 PCR2    INFO: Validate: [Dir]: meta
180322 21:36:59 PCR2    INFO: Validate: [Dir]: datadir/mysql
180322 21:37:00 PCR2    INFO: Validate: [Dir]: datadir/performance_schema
180322 21:37:00 PCR6    INFO: Validate: [Dir]: datadir/pets
180322 21:37:00 PCR6    INFO: Validate: [Dir]: datadir/sys
180322 21:37:00 MAIN    INFO: Total files as specified in image: 137
180322 21:37:00 MAIN    INFO: datadir/ibdata1 validated.
180322 21:37:00 MAIN    INFO: datadir/undo_001 validated.
180322 21:37:00 MAIN    INFO: datadir/undo_002 validated.
180322 21:37:00 MAIN    INFO: datadir/sys/sys_config.ibd validated.
180322 21:37:00 MAIN    INFO: datadir/pets/cats.ibd validated.
180322 21:37:00 MAIN    INFO: datadir/mysql.ibd validated.
180322 21:37:00 MAIN    INFO: Validate operation completed successfully.
180322 21:37:00 MAIN    INFO: Backup Image validation successful.
180322 21:37:00 MAIN    INFO: Source Image Path = /home/mysqlbackup/backups/my.mbi

mysqlbackup completed OK!

Furthermore, you can also verify that your backup has been successful by restoring the backup data on a different server and run the MySQL daemon (mysqld) on the new data directory. You can then execute SHOW statements to verify the database and table structures, and execute queries to verify further details of the database. See Section 4.2.3, “Restoring a Database” for the basic steps for restoring a backup, and see Chapter 5, Recovering or Restoring a Database for more detailed instructions.

Warning

Do not try to verify a backup by using the backup directory as a data directory to start a MySQL server. This will crash the server, and might also corrupt your backup. See Appendix A, Frequently Asked Questions for MySQL Enterprise Backup for details.