3.2.3 Restoring a Database at its Original Location

To restore a MySQL instance from a backup:

$ mysqlbackup --defaults-file=path_to_my.cnf \
  --datadir=path_to_data_directory \
	--innodb_log_files_in_group=N \
	--innodb_log_file_size=N \
  --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.