Learn how to manually backup and restore MySQL databases
This tutorial explains how to backup the information from your MySQL databases and restore it when needed.
MySQL Export: How to backup your MySQL database?
In order to create a dump file of a database used by your account you can use the phpMyAdmin tool available in your cPanel:
Once the tool page loads, you should select the database in question from the panel on the left side.
A new page will be loaded showing the structure of the selected database. To create a backup of the database, click the Export tab.
On the page that opens you can choose from using the Quick or Custom export methods. The Quick method is usually the preferred choice, but if you would like to customize the export process and output you can use the Custom one. Once you choose the appropriate method, select the desired format of the backup from the Format: drop-down and click the Gobutton.
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 a database via phpMyAdmin, first choose the database you’ll be importing data into. This can be done from the menu on the left.
A new page will be loaded showing the structure of the selected database. To import data inside the database, click the Import tab.
On the new page that opens, click the Browse button and select the backup that you want to import from your local computer. You have the option to pick 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. Once ready, click the Go button to perform the import.
The import will start and once finished you will be redirected to a page with a confirmation notification that the import was successful.