As often happens in mysterious shutdowns during large queries, things ran afowl with InnoDB on my XAMPP MySQL installation (Windows 7 x64). I rebooted and ran Startup Repair, then loaded MySQL to truncate and restart the backup restore. Only MySQL wouldn't even start.
I eventually found that it according to the log file, "something went terribly wrong". The InnoDB tablespace was corrupted. The only way to start the server was with
innodb_force_recovery = 6 in the config file, which makes tables read-only.
I have three tables: two that I would like to save and one that I was restoring. Is there a way to truncate, drop, or otherwise repair/remove the offending table, and would that solve my problem?