PDA

View Full Version : Innodb Snapshot partial backup-recovery



gloria
October 14th, 2010, 12:48 AM
Hi!

I've a doubt. We've have lots of Innodb databases sharing the same tablespace (the same ibdata). We've scheduled a weekly full backup with snapshots.

We'd like to know what would happen if we need to make a partial recovery of a corrupted database or table. Will the ibdata from the backup smash the one in the MySQL server and will we lost data???

And, if we recover the database in another server to check if it is correct before taking the risk of doing it our MySQL sever, which files should we copy from this server to the MySQL server?

paddy
October 14th, 2010, 12:28 PM
If you using shared tablespace, it is difficult to recover single database/table.
You should be using innodb file_per_table parameter. Please see http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html