To restore a MySQL instance from a backup:
Shut down the database server using your usual technique, such as the command mysqladmin shutdown.
Make sure the backup data is fully consistent, by either using the
backup-and-apply-log
option to perform the backup, or running mysqlbackup with theapply-log
option after the initial backup.Use the mysqlbackup command with the
copy-back
option. This operation copies tables, indexes, metadata, and any other required files back to their original locations as defined by the original MySQL configuration file. For the different combinations of options that you can specify as part of this operation, see Section 5.1.1.3, “Restore an Existing Backup”.
$ mysqlbackup --defaults-file=path_to_my.cnf \
--datadir=path_to_data_directory \
--backup-dir=path_to_backup_directory copy-back
...many lines of output...
mysqlbackup: Finished copying backup files.
101208 16:48:13 mysqlbackup: mysqlbackup completed OK!
Now the original database directory is restored from the backup, and you can restart the database server.