dump database

[responderman]

Hi-

I have cpanel and Linux. Can someone email me the exact steps on how to dump a database via my cpanel?

I see it's in phpmyadmin and the export feature but I don't know what to check etc and where to put the dump.

myserverbeach has to replace my hard drive on my server. I have already downloaded all my files and just need to dump the database.

Alo I will need to have someone explain how to upload/re-install
the dumped database once the hard drive is replaced.

Any help would be greatly appreciated.

thanks,
Rich
rpg@bestafs.com

[dstjohn]

Login via ssh as root
type the commands below

mysqldump --user=root --password=whatever -A --all > mysqldb_all.sql

Download the mysqldb_all.sql to your pc, there is your entire mysql database dump.

[dstjohn]

As for reinstalling it would be something like this

upload your mysqldb_all.sql file
then issue the following commands

mysql --user=root --password=whatever < mysqldb_all.sql
or
mysql < mysqldb_all.sql