Category Archives: mySQL

Where are the sql error logs dude? (cPanel mySQL)

Right here…

/var/lib/mysql

error file should be hostname.err file

 

Advertisements

What’s happening on MySQL: MySQL commands from the command line

A site is seeing issues that are most likely their bad code (known history), lots of errant php and loads of db activity, so to check this out I used PHPmyadmin on the server and a bunch of commands from here, so thanks to that person for making that page 🙂

http://www.tecmint.com/mysqladmin-commands-for-database-administration-in-linux/

Ace