You need to use the “mysqldump” command to backup a Mysql database.
Backup/Dump a Mysql database on a Linux Or Linux/cPanel server:
root@host [~]# mysqldump /var/lib/mysql/dbname > dbname.sql
Restore the .sql file in a database:
root@host [~]# mysql /var/lib/mysql/dbname < /path/to/filename.sql
Backup/Dump a Mysql database on a Linux/Plesk server:
root@host [~]# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` /var/lib/mysql/dbname > dbname.sql
Restore the .sql file on a Plesk server :
root@host [~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` /var/lib/mysql/dbname < /path/to/filename.sql
Tags: backup a database on a cPanel server, howto backup a database on Plesk server, Howto restore a .sql file, Howto: Backup and Restore a database
December 21st, 2009 at 2:46 am
nice post..
January 16th, 2010 at 12:58 pm
Have you ever thought of adding additional videos to your site to keep the viewers more engaged? I just read through the entire article and it was quite good but since I learn visually, I find videos to be very helpful. I enjoy what you guys are always coming up with. Keep up the nice work. I will check out your site regularly for some of the latest post.