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.
