Difference between revisions of "How to restore a MYSQL database phpmyadmin"
Jump to navigation
Jump to search
| Line 20: | Line 20: | ||
* 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 11:50, 7 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.
