Backing Up and Restoring Your MySQL Database

You can easily create a dump file(export/backup) of a database used by your account. In order to do so you should access the phpMyAdmin tool available in your cPanel:

phpMyAdmin

The phpMyAdmin tool will be loaded shortly.

You can select the database that you would like to backup from the drop-down menu called Database (located in the upper left corner of the page).

phpMyAdmin - Choose a database

A new page will be loaded in phpMyAdmin showing the selected database. In order to proceed with the backup click on the Export tab:

phpMyAdmin - Export

The options that you should select apart from the default ones are Save as file (which will save the file locally to your computer in an .sql format) and Add DROP TABLE (which will add the drop table functionality if the table already exists in the database backup) as shown below:

phpMyAdmin - Save as file

Click on the Go button to start the export/backup procedure for your database:

Export/backup a MySQL database

A download window will pop up prompting for the exact place where you would like to save the file on your local computer. It is possible that the download starts automatically. This depends on your browser's settings.

MySQL Import: How to restore your MySQL database from a backup

To restore (import) a database via phpMyAdmin, first choose the database you'll be importing data into. This can be done from the drop-down menu on the left. Then click the Import tab:

Importing a MySQL database via phpMyAdmin

You have the option of importing an .sql file. Use the Browse button to find it on your local computer. Note that you are given the option to choose the character set of the file from the drop down-menu just below the upload box. If you are not certain about the character set your database is using just leave the default one.

Importing an .sql file

In order to start the restore click on the Go button at the bottom-right. A notification will be displayed upon a successful database import.

Was this answer helpful?

 Print this Article

Also Read

How do I enable/disable magic quotes gpc for my PHP scripts?

The magic quotes option was introduced to help protect developers from SQL injection attacks. It...

How to Access and Manage your MySQL Database - phpMyAdmin

There are two ways to access and manage your newly created database. The first one is locally...

How to connect to the MySQL database

Configuration Settings: Host = localhost (really, put localhost) Database name =...