Restore MySQL Enterprise Backup File

Restore MySQL Enterprise Backup File

1. Shutdown MySQL server

mysqladmin -u root -p shutdown

2. Restore MySQL Backup

./mysqlbackup --defaults-file=/etc/MySQL/my.cnf --datadir=/var/lib/MySQL --backup-image=/srv/db_backup/my.mbi --backup-dir=/srv/db_backup/restore-tmp copy-back-and-apply-log --force --uncompress

3. Update file permission

chown -R mysql:mysql /var/lib/MySQL

4. Start MySQL

service start MySQL

5. Check your MySQL data to ensure that it's been successfully restored.

That's all folks!  5 steps only.  I've restored 16GB of compressed my.mbi backup file in less than half an hour.
Fyi, I referred to https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/mysqlbackup.restore.html for this.