How to Backup and or Restore your MySQL Database Using phpMyAdmin


Revision as of 11:51, 23 May 2018 by Wikiadmin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Backup your MySQL Database
1. Log into your account at Bravenet.com
2. Navigate to the Database tab and click the PHPMyAdmin link to log into your database
3. While in PHPMyAdmin, select the database you would like to backup from the left navigation tree.
Phpmyadmin mainpage.png
4. Click the Export tab
Phpmyadmin export.png
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.
Phpmyadmin droptables.png
4. Confirm by clicking Yes.
5. Click the Import tab.
6. Click the Choose File button to browse for the MySQL backup.
Phpmyadmin import.png