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

How to Backup and Restore a MySQL Database

How to Back up a MySQL Database

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


Please ensure 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, do the following:
    • Click on the Export tab.
    • Choose the Quick method to export all tables in your database.
    • Under Format, select SQL from the drop-down menu.
    • 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 a MySQL Database


Note: If you already have a target database, 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

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

Chat
Close