When restoring a MySQL database, I get the following error root@localhost:~# mysql -u sok_user -p’serverok123′ sok_db < parkingcupid.sql ERROR 1114 (HY000) at line 2137: The table 'field_data_field_monthly_price' is full root@localhost:~ How to fix ERROR 1114 (HY000) table is full? First, check if the disk on the server is full. df -h In my case server ... Read more
When deleting a table in a MySQL database, I get the following error message MariaDB [thrkhztbpt]> drop table users; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails MariaDB [thrkhztbpt]> To fix the error, run SET FOREIGN_KEY_CHECKS=0; Now the drop table SQL command will work. After you dropped the … Read more
When trying to restore a database backup to Managed DigitialOcean MySQL 8 database, i get following error root@ocp:~# mysql -u doadmin -p’BKwsQcqEGbSV3w’ -h db-sevrerok-do-user-8606188-0.b.db.ondigitalocean.com -P 25060 serverok_db < serverok_db.sql mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 3750 (HY000) at line 223: Unable to create or change a table ... Read more
After MySQL upgrade from MraiaDB 10.1 to 10.3, MySQL failed to start. On checking log, found root@localhost:/var/log/mysql# cat error.log 2019-09-23 6:30:10 0 [Note] InnoDB: Using Linux native AIO 2019-09-23 6:30:10 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-09-23 6:30:10 0 [Note] InnoDB: Uses event mutexes 2019-09-23 6:30:10 0 [Note] InnoDB: Compressed tables … Read more