Overview

There are several options available to backup your MySQL databases.

---

• Using CodeGuard
• Using Jetpack
• Using phpMyAdmin
• Using the Command Line

---

Using Site Backup & Restore

1. Select Site Backup Pro from the Files category after logging into your Bluehost control panel.
   
2. Click the Browse link underneath the MSQL databases and tables.
   
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.
   

Using phpMyAdmin

1. Log in to your Bluehost control panel. 
2. Click the phpMyAdmin icon in the Databases section.
   
3. Select the database you wish to backup the list on the right.
   
4. Click on the Export Tab.
   
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.
   
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

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.