I'm attempting to alter a 1.6 GB InnoDB table with the following query:
ALTER TABLE `table_name` ADD `field_id` int(11) unsigned DEFAULT NULL
The query fails with the following error:
1034 Incorrect key file for table 'table_name'; try to repair it
Nearly every thread on this topic (SO and elsewhere) suggests that this is due to the tmpdir running out of space.
While this seems to be the problem for many, this doesn't seem to be the case on our system.
/tmp is far from full:
I'm totally stuck. Thoughts?