How to restore a MYSQL database phpmyadmin

From Imaginet FAQ
Revision as of 09:07, 9 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 useful 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 restored, 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=625"