There are three options available to backup your MySQL databases:
1) Use the backup utility in the cPanel.
2) Manually backup using phpMyAdmin. To do this, follow these steps:
1. Login to your cPanel and click phpMyAdmin icon in Databases section.
2. Select the database you wish to export the backup from the drop-down list.
3. Click on the Export Tab.
4. Click the Select ALL link shown in blue. Make sure the radio button for SQL is selected
5. Check the "Save as file", give it a file name and click GO button.
6. You will be asked to save the .sql file to the hard drive and click OK button.
3) Use the command line in SSH.
>mysqldump -u username -p database_name > file.sql
>password
Enter your password and this will put a copy of the database into file.sql
Your are here: Home // Bluehost //
Bluehost MySQL Backup
