How do I create a MySQL backup?

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

Enter your password and this will put a copy of the database into file.sql

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What version of MySQL are you running?

The current version can be viewed in the cPanel on left side.

I can't connect to my database locally or remotely, do I have the correct server, username and password?

Since we run a shared hosting environment, we have to uniquely identify your MySQL Users to your...

How do I create an empty MySQL Database

To create the database, do the following: Log into the cpanel Click the MySQL Databases icon...

I need to Export or Import a MySQL database

Note: PhpMyAdmin can only import and export databases up to 50 MB in size. If your database is...