Re: mysqlbackup backup one of databases and restore issue

[Ben Stillman]

--include=database.* backs up the ibd and frm files for the specified database, but also the frm files for all the other databases (along with other files). So doing a copy-back restores all of the folders from the backup. MySQL docs say to delete the frm files from the backup for tables you don't want to restore before running the restore. Hypothetically you could manually restore the frm and ibd files for the specified database by copying them out of the backup datadir. This would require you to lock all of the tables in that database.

http://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/backup-partial-options.html