Our mysql ibdata1 file was deleted earlier today. This wasn't noticed until mysqld was restarted and there was no data in the tables. The machine is a CentOs VM in Xenserver. At this point a snapshot was taken. Then the mysql database was dropped and restored from a backup. The backup not as current as I'd like it to be.
I've been researching ways that ibdata might be recovered from the snapshot (ext3grep, undelete) and I briefly tried them on the machine after the snapshot but before giving up and restoring the old backups. I am looking at the snapshot now, trying to figure out how get it with making a live VM and mounting the filesystem.
I was wondering anyone had any advice or expereience if this is a pointless road to go down, or other suggestions.