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-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 126.96.36.199, “Restore an Existing Backup”.
mysqlbackup --defaults-file=...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.
Copyright © 2003, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices