It is pretty straightforward to check a MySQL / MariaDB table for a Primary Key, connect to the db server, login or open up your favorite MySQL client. Without selecting any table, issue the following command: SHOW INDEXES FROM <TABLE>…
Got the following error while trying to repair a table individually: myisamchk: error: myisam_sort_buffer_size is too small The command I was using was: myisamchk -r -f TABLE-NAME.MYI To fix this just append the following to the command above: –sort_buffer_size=2G So…
Got the following error while trying to repair a crashed DB: Mysql error : Can’t create new tempfile: *.TMD file You need to run the myisamchk command on the table in question instead of the whole database. Issue the following by hopping…
I recently experienced this error on a DigitalOcean node with 512MB ram. The full error below: Starting MySQL (Percona Server). ERROR! The server quit without updating PID file () The log had the following errors logged 2015-05-25 03:46:27 3518 [Note]…
I recently had to extract a database from a full backup, I only needed one database hardly 1MB in size but the whole backup exceeded 3GB and didn’t want to import all of it. Below is the command I found…