How to Backup and or Restore your MySQL Database Using phpMyAdmin

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

Backup your MySQL Database

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

    Select MySQL database
     
  4. Click the Export tab.

    Export MySQL Database
     
  5. Choose the Quick export method and click Go.
  6. Your export of your database will be downloaded to your local machine's default downloads location.
 
Restore your MySQL database from a Backup
  1. Choose the database you want to restore from the left navigation tree.
  2. The phpMyAdmin script that restores your database does not drop the tables first. Click the Check All check box.
  3. Click the With selected: drop down menu and choose Drop.

    Drop MySQL Tables for phpMyAdmin Import
     
  4. Confirm by clicking Yes.
  5. Click the Import tab.
  6. Click the Choose File button to browse for the MySQL backup.

    MySQL database import
     
  7. Click Go.
 

Add Feedback