How do I back up a MySQL Database?

You can backup your database two ways.

1. Click on Backup in Cpanel then click on the database name. This will download a gzipped copy to your computer.

2. Use the PHPMyAdmin feature in your control panel by clicking on MySQL and then phpmyadmin at the bottom. In PHPMyAdmin, select the database you want to backup and select "Export" tab on the right screen. Choose the tables you wish to backup (or "Select All" for all tables). Scroll down and tick "Save File As..." and click on the "Go" button. Simply save the database that begins to download, on your local computer.
  • 35 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to MySQL remotely?

Yes, you can connect to your MySQL database remotely using a client such as MySQL-Front at...

How do I create a database in MySQL?

You can create a database via your control panel by clicking on the MySQL icon. When you create...

How do I import and export a MySQL DB using phpMyAdmin?

Step 1: Open phpMyAdmin and select the database from where you want to export data and/or...

What are the connection settings for my MySQL Database?

The hostname to connect to is "localhost"; without the quotes. The database username and password...

Am I allowed to use scripts and software that connect to MySQL?

Yes! Absolutely. So long as they are hosted on your account you can use MySQL databases to run...