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

MySQL MariaDB

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, […]

Read More…

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

MySQL MariaDB

When deleting a table in a MySQL database, I get the following error message

To fix the error, run

Now the drop table SQL command will work. After you dropped the table, re-enable foreign key check with

Example

[…]

Read More…

MySQL ERROR Unable to create or change a table without a primary key

When trying to restore a database backup to Managed DigitialOcean MySQL 8 database, i get following error

This is because one of the tables in your MySQL backup don’t have primary key defined. Solution There are few ways you can fix this. Proper way is to define a primary key for the table. If […]

Read More…

MySQL Recovering after a crash using tc.log

MySQL

After MySQL upgrade from MraiaDB 10.1 to 10.3, MySQL failed to start. On checking log, found

On /var/lib/mysql folder, there is a tc.log file with 0 size. The error is solved by removing this file.

[…]

Read More…