Difference between revisions of "How to restore a MYSQL database phpmyadmin"
Jump to navigation
Jump to search
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | 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 | + | 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 | + | If you remember, we showed you how to create a backup of your database, now we 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 | + | * '''Step 1''' |
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|600px|thumb|center]] | [[File:restoredb_img1.PNG|600px|thumb|center]] | ||
| − | * Step 2 | + | * '''Step 2''' |
Select Import | Select Import | ||
[[File:restoredb_img2.PNG|600px|thumb|center]] | [[File:restoredb_img2.PNG|600px|thumb|center]] | ||
| − | * Step 3 | + | * '''Step 3''' |
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|600px|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 | + | 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. |
Latest revision as of 16:16, 13 December 2021
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, we showed you how to create a backup of your database, now we 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 restored, remember that it can take some time depending on how large the database is.
