Import large .sql file into MySQL database 1

Import large .sql file into MySQL database

Should be used for really huge database imports like tens of GB … Note: remember to navigate to the directory where your .sql file lives so you can use source on it later …

Note: if you’re not sure what these options do, please, do some research  first.

   

Change mysql collation from latin to utf8 - all tables and all columns 2

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 databases you create… But what can I say, I’m a lazy bastard after all. I keep doing the same mistake over and over again. Just […]

Optimize only fragmented tables in MySQL 3

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 you can’t do magic, but you can optimize these tables for them. For that puprose I use mysqltuner which is written in perl, download it […]

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. :PThree simple things. the number inside parenthesis indicates the error number we want to think about firstly. The number two means that mysql daemon cannot find that file. So, to solve this, try […]