Jump to: navigation, search

Difference between revisions of "How to Backup and or Restore your MySQL Database Using phpMyAdmin"


Line 1: Line 1:
 
'''Backup your MySQL Database'''
 
'''Backup your MySQL Database'''
# Log into your account at [https://bravenet.com Bravenet.com]
+
1. Log into your account at [https://bravenet.com Bravenet.com]
# Navigate to the [https://manage.bravehost.com/database Database tab] and click the PHPMyAdmin link to log into your database
+
2. Navigate to the [https://manage.bravehost.com/database Database tab] and click the PHPMyAdmin link to log into your database
# While in PHPMyAdmin, select the database you would like to backup from the left navigation tree.   
+
3. While in PHPMyAdmin, select the database you would like to backup from the left navigation tree.   
 
[[File:phpmyadmin_mainpage.png|900px]]
 
[[File:phpmyadmin_mainpage.png|900px]]
# Click the '''Export''' tab
+
4. Click the '''Export''' tab
 
[[File:phpmyadmin_export.png|900px]]
 
[[File:phpmyadmin_export.png|900px]]
# Choose the Quick export method and click Go.
+
5. Choose the Quick export method and click Go.
# Your export of your database will be downloaded to your local machine's default downloads location.
+
6. Your export of your database will be downloaded to your local machine's default downloads location.
  
 
'''Restore your MySQL database from a Backup'''
 
'''Restore your MySQL database from a Backup'''
# Choose the database you want to restore from the left navigation tree.
+
1. 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.
+
2. 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'''.
+
3. Click the '''with selected''': drop down menu and choose '''drop'''.
 
[[File:phpmyadmin_droptables.png|900px]]
 
[[File:phpmyadmin_droptables.png|900px]]
# Confirm by clicking Yes.
+
4. Confirm by clicking Yes.
# Click the Import tab.
+
5. Click the Import tab.
# Click the Choose File button to browse for the MySQL backup.
+
6. Click the Choose File button to browse for the MySQL backup.
 
[[File:phpmyadmin_import.png|900px]]
 
[[File:phpmyadmin_import.png|900px]]

Revision as of 11:48, 23 May 2018

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