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):

  1. Log in to your Hosting 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
    • The quick method will export all tables
    • Format SQL and 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.
  2. Go to the Hosting Tools.
    Enter Hosting summary
  3. In the left pane, click MySQL Management.
    Click on MySQL Management
  4. Click the Add Database icon.
    Add new MySQL Database
  5. Name the database
    Name the new MySQL Database
  6. 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
  7. Set the privileges for the new user.
    Set privileges for the new database user.
  8. Select the database that you want to import to.
  9. Click Access phpMyAdmin.
    Click on phpMyAdmin.
  10. Click the Import tab on top.
  11. Click Choose File and select the database file you want to import.
  12. Click Go.
    Select a database
  13. 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:


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