Welcome, Guest Login

Support Center

How do I backup a MySQL database?

Last Updated: Jun 09, 2014 06:15PM EDT
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
database selected.

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
steps involved.

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.

Contact Us
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found