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

Database Management: How To Backup And Restore Your Database

How To Backup Your MySQL Database

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

  1. Log into your hosting control panel, and navigate to MySQL Database
  2. In the left pane, select a database which you wish to manage
    Access phpMyAdmin
  3. In the right pane, for the selected username, click the Access icon. You are brought to the phpMyAdmin page, from which you can manage the selected database.
  4. With your database selected in the left pane:
    • Click on the Export tab on top
    • The Quick method will export all tables
    • Format SQL and Go
     
    Quick Export.
  5. Your database is available for download and other options.
    Download options

To create specific tables in a database for an on-demand backup:

  1. Log into your hosting control panel, and navigate to MySQL Database
  2. In the left pane, select a database which you wish to manage
    Access phpMyAdmin
  3. In the right pane, for the selected username, click the Access icon. You are brought to the phpMyAdmin page, from which you can manage the selected database.
  4. With your database selected in the left pane:
    • Click on the Export tab on top
    • Change the Export method to Custom
    • Select the tables you want to Export
    • Change any other Export options
    • Format SQL and Go
    • Your database is available for download and other options.
     
    Custom Export.

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 4.

To create a new MySQL database:

  1. Log into your hosting control panel, and navigate to MySQL Database
    Navigate to MySQL Database
  2. In the left pane, click Add Database icon. An Add Database dialog is displayed.
  3. Enter the database name, username, and password. The database is created for you, with the username and password applied to the first user.

    Note: If you cannot see your newly created database, click the Refresh icon in the left pane
  4. Select the database in the left panel that you want to import to
  5. Click Access phpMyAdmin
    Select a database
  6. Click the Import tab on top.
  7. Click Choose File and select the database file you want to import.
  8. Click Go.
    Choose file to import
  9. Once your database is finished importing, you will see that your new database is now populated with your imported database information.
    Successful import of database tables
yieldmanager

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