Innobackupex question

[spgriffinjr]

I know its possible to backup individual schemas with innobackupex but how do you restore an individual schema without affecting the others? Do I just copy the backup directory structure and files into the working mysql directory?

[gmouse]

For MyISAM yes, but for InnoDB see [url]Percona XtraBackup

[scott.nemes]

The process depends on if you are using MyISAM or InnoDB/XtraDB, but below are links to the manual with important information and steps on both taking the partial backup, preparing it, and restoring it:

[url]Percona XtraBackup

[url]Percona XtraBackup

[spgriffinjr]

thanks for the info. very helpful