How to Backup and or Restore your MySQL Database Using phpMyAdmin

September 8, 2018 Off By admin

How to Backup and or Restore your MySQL Database Using phpMyAdmin
Backup your MySQL Database

Log into your cPanel account by pointing a browser to http://IPAddressOfServer:2083 and using the credentials provided.
On the Home screen, scroll down to Databases and click on phpMyAdmin.
Select the database you would like to backup from the left navigation tree.

Select MySQL database

Click the Export tab.

Export MySQL Database

Choose the Quick export method and click Go.
Your export of your database will be downloaded to your local machine’s default downloads location.

Restore your MySQL database from a Backup
Choose the database you want to restore from the left navigation tree.
The phpMyAdmin script that restores your database does not drop the tables first. Click the Check All check box.
Click the With selected: drop down menu and choose Drop.

Drop MySQL Tables for phpMyAdmin Import

Confirm by clicking Yes.
Click the Import tab.
Click the Choose File button to browse for the MySQL backup.

MySQL database import

Click Go.