To restore a MySQL instance from a backup:
Shut down the database server using your usual technique, such as the command mysqladmin shutdown.
Use the mysqlbackup command with the
copy-backoption. 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 220.127.116.11, “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.