MySQL ERROR 1114 (HY000) at line 2137: The table ‘X’ is full

When restoring a MySQL database, I get the following error

How to fix ERROR 1114 (HY000) table is full?

First, check if the disk on the server is full.

In my case server disk was not full. Next try increasing the value for variables tmp_table_size and max_heap_table_size.

Edit file

Under [mysqld] section, add

Restart MySQL

After this change MySQL database restore worked without giving any error.

If the above solution did not fix your problem, check the following.

Check Mysql variables innodb_data_file_path

If innodb_data_file_path variable have a max value set, you should update it. In this case, we don’t have a max value.

Verify innodb_file_per_table is set to 1.

See MySQL

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *