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.
    Dashboard
  2. In the left pane, click MySQL Management.
    Click on MySQL Management
  3. Click Manage on the database you want to access
    Manage your domain
  4. Click on phpMyAdmin for the selected database.
    Click on phpMyAdmin.
  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.
    Quick Export.
  6. Your database is available for download and other options.
    Download options


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.
    Dashboard
  2. In the left pane, click MySQL Management.
    Click on MySQL Management
  3. Click the Add Database icon.
    Add new MySQL Database
  4. Name the database
    Name the new MySQL Database
  5. Create a username and password. The database is created for you, with the username and password applied to the first user.
    Set user and password for the new MySQL Database
  6. Set the privileges for the new user.
    Set privileges for the new database user.
  7. Select the database that you want to import to.
  8. Click Access phpMyAdmin.
    Click on phpMyAdmin.
  9. Click the Import tab on top.
  10. Click Choose File and select the database file you want to import.
  11. Click Go.
    Select a database
  12. Once your database is finished importing, you will see that your new database is now populated with your imported database information.
    Select a database
 

Related Articles: