Export a Database via cPanel
To export a MySQL database via cPanel:
-
Log into cPanel
-
Click phpMyAdmin from the Databases section

-
From the left-hand sidebar click the name of the database you want to export
-
Click the Export tab/button up near the top

-
Choose your export method and your format from the available dropdowns

-
Click the Go button
-
Choose where to save your export, and what to name it in the pop-up

Export a Database via Command Line
mysqldump -u DBUSER -pDBPASS DBNAME > dump.sql
Replace the text in the uppercase letters with the appropriate information:
DBUSER - Database user with privileges to the database
DBPASS - Password for the database user
DBNAME - Database name
If your password contains special characters like (* ? [ < > & ; ! | $ ), you will either need to escape them with a backslash, put the password between single quotes, or leave the password out (you'll be prompted to enter a password).
Here are some examples:
Escaped Password
mysqldump -u DBUSER -pM\*Y\?P\[A\<S\>S\&W\;O\!R\|D\$ DBNAME > dump.sql
Password In Quotes
mysqldump -u DBUSER -p'M*Y?P[A<S>S&W;O!R|D$' DBNAME > dump.sql
No Password
mysqldump -u DBUSER -p DBNAME > dump.sql
Also, if you're trying to export a database that's located on a different server, you'll need to set the database server hostname (by default the hostname is localhost or 127.0.0.1 ):
mysqldump -h DBHOST -u DBUSER -p DBNAME > dump.sql
|