MySQL and ERROR 1114 (HY000): The table TABLE is full
Posted on April 26, 2009 - Filed Under Tech
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.
Popularity: 8% [?]
Hits for this post: 7995
Similar Posts
- MySQL – fields table is not good idea
- MySQL, collations and Rails – or server, database, connection – that is not all
- Find people with similar interests
- Acts As Taggable gem and MySQL duplicate key
- Uploading photos to Facebook with RFacebook
Comments
One Response to “MySQL and ERROR 1114 (HY000): The table TABLE is full”
-
A Store Speed Optimization in Progress - osCommerce Community Support Forums - Page 37 on
November 12th, 2009 20:41
[...] could ever test with. Perhaps there is maximum limit for such temporary tables or perhaps you have run out of disk space for your database?. Try leaving the ENGINE=MEMORY part out then it becomes an ordinary MySQL table [...]
Leave a Reply
