Difference between revisions of "How to restore a MYSQL database phpmyadmin"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
Login to http://phpyadmin.yourdomainame.co.za and select the database. | Login to http://phpyadmin.yourdomainame.co.za and select the database. | ||
| − | [[File:restoredb_img1.PNG|thumb|center]] | + | [[File:restoredb_img1.PNG|600px|thumb|center]] |
* Step 2 | * Step 2 | ||
Select Import | Select Import | ||
| − | [[File:restoredb_img2.PNG|thumb|center]] | + | [[File:restoredb_img2.PNG|600px|thumb|center]] |
| Line 16: | Line 16: | ||
Click on the Browse button and locate the .sql backup you made. | Click on the Browse button and locate the .sql backup you made. | ||
| − | [[File:restoredb_img3.PNG|thumb|center]] | + | [[File:restoredb_img3.PNG|600px|thumb|center]] |
* Step 4 | * 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. | 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. | ||
Revision as of 17:08, 2 November 2012
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.
- Step 2
Select Import
- Step 3
Click on the Browse button and locate the .sql backup you made.
- 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.
