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…