How to Backup a MySQL Database | Bluehost Support
Support
  1. bluehost knowledge base

How to Backup a MySQL Database

Overview

There are several options available to back up your MySQL databases.



Using phpMyAdmin

Note: Bluehost provides two interface choices for account management: the original 'Bluerock' control panel and the newer 'Account Manager' designed for easier use. Although both offer similar management features, the settings, and locations might differ. Refer to 'Account Manager vs. Bluerock' to understand which guidelines to follow.

Account Manager

  1. Log in to your Bluehost control panel.
  2. Click the Hosting tab from the side navigation.
  3. Under Quick Links, click on cPanel.
    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

Backup process using phpMyAdmin

  1. Click the phpMyAdmin icon in the Databases section.
    am-php-my-admin
  2. Select the database you wish to backup the list on the right.
    legacy-your-database
  3. Click on the Export Tab.
    legacy-select-database
  4. Choose your preferred Export method by clicking the radio button. 
  5. Click this▼ icon to choose the database format (e.g., SQL, CSV, XML, PDF, etc.).
  6. Click the GO button.
    legacy-export-method
  7. You will be asked to save the .sql file to the hard drive, select the desired path, and click the OK button.

    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.

Using the Command Line

Enter the following command to export your database:

mysqldump -u username -p database_name filenamehere.sql

Please see the separate Help Desk article here.

After pressing Enter, 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 assistance with any of these procedures, please contact our Support department.

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.