Category MySQL

MySQL

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 any table, issue the following command: SHOW INDEXES FROM <TABLE>…

theshell
November 29, 2016

CentOS 6, MySQL

myisamchk: error: myisam_sort_buffer_size is too small

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…

theshell
August 7, 2015

CentOS 6, MySQL

Mysql error : Can’t create new tempfile: *.TMD file

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…

theshell
August 7, 2015

CentOS 6, MySQL

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: 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]…

theshell
May 25, 2015

CentOS 6, MySQL

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 import all of it. Below is the command I found…

theshell
November 21, 2014