Import large .sql file into MySQL database 1

Import large .sql file into MySQL database

This content is restricted to subscribers

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

This content is restricted to subscribers

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)

This content is restricted to subscribers