Hoaxblog.com

This is really the most handy tool for mysql databases. A built in mysqldump can be used via shell to dump mysql databases within a few minutes. Sometimes dumping backups using phpmyadmin is too hazardous. So it’s really a necessary tool and fast too. I have listed this commands and i believe this should be useful to lots of system admins

Taking Database Backup

mysqldump -uuser -pmysqluserpassword database_name > database_name.sql

Restoring a Database

mysql -uuser -pmysqluserpassword database_name < database_name.sql

Here, you need to replace the user with the proper database user who has access to that specific database and the mysqluserpassword directs the password of that specific user. Here, one important thing is database_name.sql file can be replaced with the location of the sql file, suppose if you want to save it or retrieve from /home/backup then you can put /home/backup/database_name.sql to do that.

I have seen, lots of my customers see the 2002 phpmyadmin error while connecting from cpanel. After some small researches, i found this that, phpmyadmin by default tries to connect via tcp. And if you have query cache enabled, then for cache buffering it wont allow new tcp connections. So the best way to solve this problem is by resetting tcp connection into direct socket connection. A general Cpanel server can get fixed by following the steps written below:

Login as root and edit /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php. To do this, do the following;

1

nano /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php

Find

1

$cfg[’Servers’][$i][’socket’] = ”;

Change this settings to:

1

$cfg[’Servers’][$i][’socket’] = ‘/var/lib/mysql/mysql.sock’;

On the next line also change the following settings:

1

$cfg[’Servers’][$i][’connect_type’] = ‘tcp’;

To

1

$cfg[’Servers’][$i][’connect_type’] = ’socket’;

Have a nice reading and work tight :p