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.
Leave a comment