MySQL / InnoDB / Incorrect key file for table Error

InnoDB is insanely picky about it's config; if something's not right, it'll just give up and go home. To make a change to the log file size without data loss:

1. Revert any config changes you've made to the log file size and start MySQL again.
2. In your running MySQL: SET GLOBAL innodb_fast_shutdown=0;
3. Stop MySQL
4. Make the configuration change to the log file size.
5. Delete both log files.
6. Start MySQL. It will complain about the lack of log files, but it'll create them and all will be well.

I managed to rectify the problem... although I don't really know what the cause of it is so it may happen again of course.

So basically I stopped MySQL and did a myisamchk on the products table (in it's new schema) by:

1. sudo su -ing
2. cd /var/lib/mysql/{scema_name}/
3. myisamchk -o -f products

I had tried this before, but it was going to take days with a full table. But because the table now had no records in it, it was done in a few seconds and this seemed to clear whatever flag MySQL sets for crashed tables.

So it has now stopped trying to repair it every time the server boots up and I have successfully written nearly 5 million rows back to the table without a hitch.

The Lesson?

Back up your table data, empty the table, do a myisamchk -o on the empty table and then re-INSERT your data

Interestingly I tried to do a myisamchk -r but I kept getting a Segmentation Fault.