Change mysql collation from latin to utf8 – all tables and all columns

Change mysql collation from latin* to utf8 can be done by simply stop being a lazy bastard and, take the time to change the default mysql collation for the new…Change mysql collation from latin* to utf8 can be done by simply stop being a lazy bastard and, take the time to change the default mysql […]

Optimize only fragmented tables in MySQL

MySQL tables are often fragmented and most of the clients/devs don’t give a f’ about it! They ‘re happy just to blame the sysadmin. So since you’re not a DBA…MySQL tables are often fragmented and most of the clients/devs don’t give a f’ about it! They ‘re happy just to blame the sysadmin. So since […]

How To solve – ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Something like: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) Ok this was tough enough to find. :P Three simple things. the number inside parenthesis…Something like: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) Ok this was tough enough to find. :P Three simple things. […]