How do I export a cPanel database via SSH?

 

Export A MySQL Database

1. Using SSH, execute the following command:

2. mysqldump -u username -p database_name > dbname.sql

3. You will be prompted for a password, type in the password for the username and press Enter. Replace username, password and database_name with your MySQL username, password and database name.


File dbname.sql now holds a backup of your database and is ready for download to your computer.

  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I clear the exim sendmail statistics on CPanel / WHM ?

  If the size of your eximstats database is getting large ( you can check...

How do I import a cPanel database via SSH?

Importing large databases is via a web based utility such as; PHPMyAdmin can...

Using suPHP

What is suPHP? suPHP is a tool for executing PHP scripts with the permissions of their...