Knowledgebase

How do I create a backup of a MySQL database?

There are three options available to backup your MySQL databases:

1) Use the Site Backup & Restore tool. To do this, follow these steps:

1. Select "Site Backup & Restore" from the Files category, after logging into cPanel.
2. Select "MySQL Database (Individual)" option.
3. Select the desired archive date.
4. Select the desired database.
5. Click "Download file" option on the right, or from the interactive mouse-over menu.

2) Export 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 the "GO" button.
6. You will be asked to save the .sql file to the hard drive; select the desired path, and click the OK button.

3) Use the command line in SSH

  mysqldump -u username -p database_name > filenamehere.sql
 

Note: 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.