Backing up your MySQL database can be done couple different ways.
Method #1 Using the phpMyAdmin web interface included in the Hsphere CP
Method #2 Using command line utility "mysqldump"
Using the phpMyAdmin Method:
To access phpMyAdmin, you will need to follow these steps.
1 ) Login to your Hsphere Control Panel
2 ) Under Databases section, You will see MySQL click on this.
3 ) Click on the Database name link you wish to manage through phpMyAdmin
4 ) You will see this hyperlink once you have clicked on database name:
"Built in phpMyAdmin control panel" click on that to launch it.
phpMyAdmin can export your entire database into a .sql file by
selecting the "Export" page found at top of screen, once you have
Steps on export screen:
1 ) Select all tables
2 ) Select "Structure and data"
3 ) Select "Add drop table"
4 ) Select "Enclose table and field names with backquotes"
5 ) Select "Save as file"
6) Then click "Go" button
You will be prompted to save the dump file on your computer.
Using the mysqldump command line tool method:
To use MySQL command line dump tool, you would need to either have a
dedicated server, vps server, or cloud server. If you are on a
shared/reseller account, and have access to download MySQL client
package off their website you can do this also as long you are aware of
It's more of an advanced method, but useful to overcome timeout issues
with phpMyAdmin such as if you have really large database.
mysqldump -u mysqluser_here -p -h mysqlserverhostnamehere databasename_here > databasename_here.sql
You will now be prompted for the MySQL user account password which will look like this: "Enter password:"
Note: To find the hostname you can locate that information in the control panel by following these steps.
Hsphere >> Databases >> MySQL >> Hostname will be displayed here.