deleted innodb tables in linux

[sfullman]

I had some innodb tables and i deleted the files representing them from the command line in linux. OK, so you'd think there would be no problem but not so, I try to create those tables again and mysql throws back an error "cannot create tablename.frm" or "table already exists"

Anyway to repair the innodb data table??

Thanks,
Samuel

[MarkR]

Deleting MySQL's data files is something that you just should NOT do.

This is a hack, but might work:

1. ON your development server (which runs the same version of mysql etc), create a new table with the same name and schema as the deleted one (with ENGINE=InnoD😎
2. Shut down both servers
3. Copy the .frm file
4. Start the production server back up

I don't know if this would work - but you could always try engineering the same fault on your dev server to try it out.

Otherwise I'm afraid you're going to be restoring it from a backup.

Note that .frm files don't change very much, so you might get away with restoring it from a backup. If that fails you'll need to restore the entire table from the last DB backup.

Mark