I've a database about which I know little, but I do have a structure-only dump of an identically-structured database.
It's mostly innodb tables, and the ib_logfile files seem intact (other innodb tables are working). All the frm files, though, are empty. I've found a couple of how-tos which involve recovering each table using the ibd files, but I've only got four ibd files.
Anyone got any hints on how else I can go about doing this? I'm expecting a procedure along the lines of: 1) Restore the dump of the structure somewhere 2) Use a tool to copy the non-frm files into that directory 3) Coerce MySQL into starting and Doing The Right thing 4) dump the data 5) restore the dump into a production db but obviously I'll take what I'm given :)
Restoring from backup is not an option, I'm afraid. I've (yes, belatedly) initiated backups on all the working dbs now :)
