1. bluehost knowledge base

 

MySQL Database Restore

There are three options available to backup your MySQL databases:

Using Site Backup & Restore

  1. Log in to your Bluehost control panel.
  2. Under the Files section, select Site Backup & Restore.
  3. Click the Browse under MySQL.
  4. Select the desired archive date.
  5. Select the desired database.
  6. Click the Restore option on the right or from the interactive mouse-over menu.

Using phpMyAdmin

  1. Log in to your Bluehost control panel.
  2. Bluerock - Click the Advanced tab from the side navigation menu to the left.
    Legacy - If you are not in the cPanel bar, select the cPanel sub-tab at the top of the account.
  3. Under the Database section, select phpMyAdmin.
  4. Select the database you wish to import the backup from the drop-down list.
  5. Click on the Import tab.
  6. Click the Choose File button.
  7. Click the Go button.

    Note: This can take a significant period of time, depending on the size of the file being imported, the number of operations the .sql file must perform, and a number of other variables.

Pro Tip! If you are unsure whether the account uses the Legacy or Bluerock interface, please see Rock vs. Legacy to determine which steps to follow.

Using the Command Line

Use the command line in SSH. Please see the separate Helpdesk article here.

mysql -p -u username database_name < file.sql

Note: You will be prompted for your MYSQL password. Enter your password, and this will export a copy of the database into your specified filename.

For further assistance, you may contact our Chat Support or Phone Support via 888-401-4678. You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.