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:
- Select "Site Backup & Restore" from the Files category, after logging into cPanel.
- Select "MySQL Database (Individual)" option.
- Select the desired archive date.
- Select the desired database.
- Click "Download file" option on the right, or from the interactive mouse-over menu.
2) Export using phpMyAdmin. To do this, follow these steps:
- Login to your cPanel and click phpMyAdmin icon in Databases section.
- Select the database you wish to export the backup from the drop-down list.
- Click on the "Export" Tab.
- Click the "Select ALL" link shown in blue. Make sure the radio button for "SQL" is selected.
- Check the "Save as file", give it a file name, and click the "GO" button.
- 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.