MySQL and ERROR 1114 (HY000): The table TABLE is full

Recently I did some site maintenance and had to dump MySQL database and upload it again. I was surprised when during loading data back to database process have stopped with error:

ERROR 1114 (HY000) at line 1052: The table 'searches' is full

It was MySQL 5.0, without cluster configuration. Google lead me to answers related to cluster setup, so I got quickly frustrated. It would be good for MySQL to provide some database of most common reasons for errors reported by MySQL.

This time reason was quite trivial – there was not enough space on file system to upload database. Why? I was changing MySQL setup to innodb_file_per_table. Since when doing such change You won’t get back space allocated to old database in file ibdata1 in mysql directory. Since database was not so small there was not enough space to create new database.

Join the Conversation

1 Comment

Leave a comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.