MySQL Database Restore | Bluehost Support
Support
  1. bluehost knowledge base

MySQL Database Restore

Backing up your MySQL databases is crucial for data integrity and recovery. Fortunately, there are three primary methods to consider: Using Backup and Restore, utilizing phpMyAdmin, or employing the Command Line. Choose the option best suited for your expertise and needs.



Using Site Backup & Restore

Before you begin, log in to your Bluehost account and access cPanel.

Account Manager

  1. Log in to your Bluehost control panel.
  2. Click the Hosting tab from the side navigation.
    bh-am-hosting
  3. Click on the cPanel button under the Quick Links section.
    am-cpanel

Bluerock

  1. Log in to your Bluehost control panel.
  2. Click the Advanced tab from the side navigation menu to the left.
    rock-bh-advanced-tab

Accessing Backup

Once you're in cPanel, proceed to the following steps:

  1. Under the Files section, select Backup.
    cpanel-backup
  2. Once you're on the Backups page. You have an option to click on the specific MySQL Database you want to backup.
    download-mysql-database
  3. Click the Restore option on the right. From there, you can select the database backup and click Upload.
    restore-mysql-database

Accessing Backup Wizard

Another option is the Backup Wizard, which offers the same functionality but with a different user interface. Check out the following steps:

  1. In the cPanel dashboard, under the Files section, click on Backup Wizard.
    backup-wizard
  2. Once you're in the Backup Wizard, click Backup.
    backup-wizard-backup
  3. Under 'Select Partial Backup,' select MySQL Databases.
    backup-wizard-mysql-database
  4. Click on the database name to start downloading the MySQL database you're working on.
    backup-wizard-mysql-databases-download

Using phpMyAdmin

Once you're in cPanel, follow the steps below:

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.

  1. Under the Database section, select phpMyAdmin.
    am-php-my-admin
  2. Select the database you wish to import the backup from the drop-down list. Next, click on the Import tab.
    mysql-database-import
  3. Select Choose File.
    database-choose-file
  4. Click on the Import tab.
    database-php-import

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.

If you need further assistance, feel free to contact us via Chat or Phone:

  • Chat Support - While on our website, you should see a CHAT bubble in the bottom right-hand corner of the page. Click anywhere on the bubble to begin a chat session.
  • Phone Support -
    • US: 888-401-4678
    • International: +1 801-765-9400

You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.