The Shell Guru
TheShellGuru provides the best in-depth tutorials for Linux, Mac OSX and Windows. Learn to utilize your server, or fix that pesky problem yourself!
Menu
  • Home
  • CentOS
  • Ubuntu
  • Windows 10
  • Apple OS X
  • WHM/cPanel
  • Plesk
  • TheAndroid.Guru

MySQL

Check MySQL / MariaDB table for Primary Key

Check MySQL / MariaDB table for Primary Key

  • November 29, 2016
  • MySQL
  • 0 Comments
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…

myisamchk: error: myisam_sort_buffer_size is too small

  • August 7, 2015
  • CentOS 6
  • 0 Comments
Got the following error while trying to repair a table individually: [crayon-60056db00cb09046241151/] The command I was using was: [crayon-60056db00cb0e181232669/] To fix this just append the following to the command above:…

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

  • August 7, 2015
  • CentOS 6
  • 0 Comments
Got the following error while trying to repair a crashed DB: [crayon-60056db00cccf553391927/] 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

  • May 25, 2015
  • CentOS 6
  • 0 Comments
I recently experienced this error on a DigitalOcean node with 512MB ram. The full error below: [crayon-60056db00ce54085184350/] The log had the following errors logged [crayon-60056db00ce58555674457/] Turns out the VPS did…

Extracting a single database a complete mysql dump file

  • November 21, 2014
  • CentOS 6
  • 0 Comments
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…
Recent Posts
  • Row size too large (> 8126). Changing some columns to TEXT or BLOB… | Mysql / MariaDB
  • Unable to register authentication agent. Cannot determine user of subject Error registering authentication agent.
  • upstream timed out (110: Connection timed out) while reading response header from upstream, client: X.X.X.X | 504 Gateway Timeout
  • GoAccess – Missing development files for the GeoIP library
  • How to convert CER to PFX | SSL Certificates
Categories
  • Apple OS X
  • CentOS
  • CentOS 6
  • CentOS 7
  • General Linux
  • Kali Linux
  • Magento
  • MySQL
  • MySQL
  • Odoo
  • Plesk
  • Ubuntu
  • Uncategorized
  • Varnish
  • WHM/cPanel
  • Windows 10
  • ZFS
  • Zimbra
Tag Cloud
add apache centos centos 7 centos 7.2 compile crash el capitan enable error fix install installation issue linux mac mac os mariadb mount mysql new nginx os osx php php-fpm reboot restart server setup sierra source terminal ubuntu ubuntu 16.04 ubuntu 16.04 lts ubuntu 18.04 lts ubuntu 19.04 update upgrade varnish windows 10 yosemite yum zfs
WPTuts Powered by WordPress and WPExplorer Themes
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok