How to restore a MYSQL database phpmyadmin - Revision history

Desmond at 14:16, 13 December 2021

2021-12-13T14:16:52Z

Dane at 07:07, 9 November 2012

2012-11-09T07:07:03Z

Dane at 09:50, 7 November 2012

2012-11-07T09:50:53Z

Dane at 15:08, 2 November 2012

2012-11-02T15:08:04Z

Dane at 14:30, 2 November 2012

2012-11-02T14:30:08Z

Dane at 14:29, 2 November 2012

2012-11-02T14:29:54Z

New page

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.

[[File:restoredb_img1.PNG|thumb|center]]

* Step 2
Select Import
[[File:restoredb_img2.PNG|thumb|center]]

* Step 3

Click on the Browse button and locate the .sql backup you made.
[[File:restoredb_img3.PNG|thumb|center]]

* 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.

@@ 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.
-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]]).
+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'''

← Older revision		Revision as of 09:50, 7 November 2012
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.

← Older revision		Revision as of 14:30, 2 November 2012
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.

@@ 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 usesfull 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 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
+* '''Step 1'''
   Login to http://phpyadmin.yourdomainame.co.za and select the database.
   [[File:restoredb_img1.PNG|600px|thumb|center]]
-* Step 2
+* '''Step 2'''
   Select Import
   [[File:restoredb_img2.PNG|600px|thumb|center]]
-* Step 3
+* '''Step 3'''
   Click on the Browse button and locate the .sql backup you made.
   [[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 restored, remember that it can take some time depending on how large the database is.