Check MySQL / MariaDB table for Primary Key
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…
MySQL
myisamchk: error: myisam_sort_buffer_size is too small
Got the following error while trying to repair a table individually: [crayon-5c492d59ed8dd161055295/] The command I was using was: [crayon-5c492d59ed8e7033495531/] To fix this just append the following to the command above:…
Mysql error : Can’t create new tempfile: *.TMD file
Got the following error while trying to repair a crashed DB: [crayon-5c492d59edbf4826984479/] You need to run the myisamchk command on the table in question instead of the whole database. Issue the…
Starting MySQL (Percona Server). ERROR! The server quit without updating PID file – Percona
I recently experienced this error on a DigitalOcean node with 512MB ram. The full error below: [crayon-5c492d59edec3622304013/] The log had the following errors logged [crayon-5c492d59edece128799944/] Turns out the VPS did…
Extracting a single database a complete mysql dump file
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…