3.2.3 Restoring a Database at its Original Location

Shut down the database server using your usual technique,
such as the mysqladmin shutdown command.

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 the
apply-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.

If the MySQL data directory already contains files (damaged
or out of date, so that you need to replace them), also
specify the --force option to enable
overwriting.