MySQL

Some errors and their solutions in MySQL.

ERRO(2006): MySQL server gone away

To avoid this error set the max-allowed-packet of MySQL global variable.

mysql> set global set max_allowed_packet =10000000;

MySQL Dump on windows.

Suppose your mysql is installed at following directory, and username of mysql is root and password is blank then:-

Bin directory- C:\Program Files\MySQL\MySQL Server 5.1\bin

-Open command prompt and got the bin directory of mysql.
-Use the following command syntax to take the dump of mysql database of table.

mysqldump --user= --password= >path to directory

e.g. mysqldump database --user=root --password= >D:\\db.sql