MySQL Backup

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.

  • 33 Usuários acharam útil
Esta resposta lhe foi útil?

Artigos Relacionados

Restoring a Backup Created with the Site Backup & Restore tool

Problem: How do I restore a backup created with the Site Backup & Restore tool? Solution:...

cPanel Backup Utility: Email Aliases and Filters

Problem: What are the aliases or filters for in the Backup Utility Tool? Solution: Aliases are...

MX Backup Services

Problem: Do you have MX Backup services? Solution: We do not provide MX Backup services.

MySQL Backup Date Discrepencies

Problem: Help! The dates on the available database backups are older than the date listed on the...

MySQL Database Restore

Problem: How do I restore a previously-saved MySQL Database? Solution: This procedure will...