How do I create a MySQL backup?

There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel account or you can manually backup using phpMyAdmin. 

To manually backup using phpMyAdmin follow these steps: 
- Login to your control panel at www.yourdomain.com/cpanel 
- Click on 'phpMyAdmin' under the 'Databases' menu
- From the dropdown list to the left, choose the database you wish to export the backup from. 
- Click on the 'Export' Tab. 
- Click the 'Select All' link shown in blue, then tick the 'Save as file' box and 'Go'. 
-  You will be asked to save the .sql file to the hard drive, click 'Save'. 
- Choose the location to save to and click 'Save'.

Your database has now been exported.

Was this answer helpful?

 Print this Article

Also Read

Do I use localhost or remotemysqlhost for my mysql connection?

You can view whether your account is using localhost or remotemysql host in your cPanel...

Remote Access To MySQL Database Server?

Host name = (use the server IP address) Database name = (cpanelUsername_databaseName) Database...

How do I create a MySQL database?

To create a MySQL database please follow the steps below:- Login to your control panel...

How can I connect to a MySQL database from Dreamweaver?

To connect to a MySQL database from Dreamweaver follow the below steps:Login to your cPanel...

How do I import a MySQL database?

To import a database follow the below steps:I have a backup of my database that I need to...