Difference between revisions of "How to restore a MYSQL database phpmyadmin"
Jump to navigation
Jump to search
| 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 useful to know as this is something that you will be doing on a regular basis if you are moving websites ect. | 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''' | ||
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.
