How to restore a MYSQL database phpmyadmin

From Imaginet FAQ
Revision as of 17:08, 2 November 2012 by Dane (talk | contribs)
Jump to navigation Jump to search

The previous tutorial (How to drop all the database tables) showed you how to drop all the database tables. Being able to restore a database is really usesfull to know as this is something that you will be doing on a regular basis if you are moving websites ect.

If you remember I showed you how to create a backup of your database, now I will show you how to restore your database from the backup that you made using this tutorial (How to backup a MYSQL database using phpmyadmin).

  • Step 1
Login to http://phpyadmin.yourdomainame.co.za and select the database.
Restoredb img1.PNG
  • Step 2
Select Import
Restoredb img2.PNG


  • Step 3
Click on the Browse button and locate the .sql backup you made.
Restoredb img3.PNG
  • Step 4
The final step is to click on the go button and your database should be restorted, remember that it can take some time depending on  how large the database is.
Retrieved from "https://www.imaginet.co.za/kb/index.php?title=How_to_restore_a_MYSQL_database_phpmyadmin&oldid=319"