1. bluehost knowledge base

How to Backup a MySQL Database

Summary

There are three options available to backup your MySQL databases.



Using Site Backup & Restore

Site Backup Pro is not available to users on Rock accounts. For more information, please see Rock vs. Legacy.
  1. Select Site Backup Pro from the Files category after logging into your Bluehost control panel.
    legacy-site-backup-pro
  2. Click the Browse link underneath the MSQL databases and tables.
    legacy-mysql-browse
  3. From the Backup section, click the ▼ icon, then choose the preferred types of backup along with the date and time from the drop-down menu that appears.
  4. After choosing the preferred type of backup, click the checkbox for the preferred archive database and date.
  5. Click the download zip.
    legacy-backup-date-and-time

Using phpMyAdmin

  1. Log in to your Bluehost control panel. 
  2. Click the phpMyAdmin icon in the Databases section.
    legacy-php-myadmin
  3. Select the database you wish to backup the list on the right.
    legacy-your-database
  4. Click on the Export Tab.
    legacy-select-database
  5. Choose your preferred Export method by clicking the radio button. 
  6. Click this▼ icon to choose the database format (e.g., SQL, CSV, XML, PDF, etc.).
  7. Click the GO button.
    legacy-export-method
  8. 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.