

-defaults-file: Path to the MySQL configuration file (typically server-my.cnf) in your backup files.Note the following options for mysqlbackup: Then, to start the restore, use the copy-back-and-apply-log command of mysqlbackup to restore your database: $ mysqlbackup \ Copy your backup files (if you followed my other post, this is a folder like “ _04-00-07“) to the server, where you want to restore the backup.Also install the mysqlbackup binaries on the same server. Install the MySQL binaries on your server, following the standard installation for MySQL Enterprise Edition.

In this article, I will restore my backup on a completely seperate server. Of course, the most important part of the backup is not “making the backup” but the restore of said backup! A backup is worthless if you cannot restore it. In another post I explained how to create a full backup using MySQL Enterprise Backup.
