How to Backup and Restore a MySQL Database

Creating a Backup of a MySQL Database via the phpMyAdmin Export Method

You can download a backup of your MySQL database by exporting its .sql file via the phpMyAdmin.

Here are the steps to export your MySQL database.

Log in to your Account Manager.
Click Hosting in the left-hand menu.
Navigate to the hosting plan where your database is.
If your account has multiple hosting plans, click the Manage button of the hosting plan where your database is located.
In the left pane, click on MySQL Management.
Look for the database you want to export to and click its Manage button.
On the Database Management page, click the phpMyAdmin link.
With the database selected in the left pane, click the Export tab in the top menu.
Select Quick as the Export method.
Select SQL from the Format drop-down menu.
Click the Go button to initiate the download/export process.

Your database will be downloaded into your computer as a .sql file.

To export your MySQL database.

Log in to your Account Manager.
Click Hosting in the left-hand menu.
Navigate to the hosting plan where your database is.
If your account has multiple hosting plans, click the Manage button of the hosting plan where your database is located.
In the left pane, click on MySQL Management.
On the MySQL Management page, click + Add MySQL Database.
Enter a name for your database, then click Next.
Type your database username and password, then click on Save.
In the next pop-up, set the database privileges.
On the Database Management page, click the phpMyAdmin link.
With the database selected in the left pane, click the Import tab in the top menu.
Click the Choose File button and select the database file you want to import.
Scroll down and click the Go button.
Once your database is finished importing, you will see that your new database is now populated with your imported database information.