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
• Using phpMyAdmin
• Using the Command Line

---

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.
   
3. Click on the cPanel button under the Quick Links section.
   

Bluerock

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

Accessing Backup

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

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

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.
   
2. Once you're in the Backup Wizard, click Backup.
   
3. Under 'Select Partial Backup,' select MySQL Databases.
   
4. Click on the database name to start downloading the MySQL database you're working on.
   

Using phpMyAdmin

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

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

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