1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Article

How to Backup and Restore a MySQL Database

Backup a MySQL database

To create an on-demand MySQL database backup (all tables):

Please make sure that you have a current hosting plan before creating a database; otherwise, this step will not be visible to your account.

  1. Log in to your Hosting Dashboard.
  2. In the left pane, click MySQL Management. %%8267_2%%
  3. Click Manage on the database you want to access %%8267_3%%
  4. Click on phpMyAdmin for the selected database. %%8268_9c%%
  5. With your database selected in the left pane:
    • Click on the Export tab.
    • Next, choose the Quick method to export all tables in your database.
    • Under Format, select SQL from the drop-down menu. Then click Go.
  6. Your database is available for download and other options. %%8268_9e%%

Important: If your database is larger than 64MB, you may want to download separate groups of database tables instead of everything all at once. We recommend this because the maximum file size you can upload when restoring your database is 64MB (65,536KB).

How To Import Your MySQL Database

Note: If you already have a target database, you can skip to step 6.

To create a new MySQL database:

  1. Log in to your Hosting Dashboard.
  2. In the left pane, click MySQL Management. %%8267_2%%
  3. Click the Add Database icon.%%8268_1%%
  4. Name the database %%8268_2%%
  5. Create a username and password. The database is created for you, with the username and password applied to the first user. %%8268_3%%
  6. Set the privileges for the new user. %%8268_4%%
  7. Select the database that you want to import to.
  8. Click Access phpMyAdmin. %%8268_9c%%
  9. Click the Import tab on top.
  10. Click Choose File and select the database file you want to import.
  11. Click Go. %%1856_2%%
  12. Once your database is finished importing, you will see that your new database is now populated with your imported database information. %%1856_4%%

Related Articles:

Thanks for visiting! Since you landed on this page of our website, we wanted to let you know you visited one of our paid endorsers while researching your purchase. close