How to Restore MySQL database using PHPMyAdmin

Previously, i have teach you how to backup the MySQL database. Now, i will brief you the simple steps on how to restore MySQL database using phpmyadmin. This steps only applicable for the database that was installed with phpmyadmin such as LAMP server, Wamp server and XAMPP server. Most of the students or for the development peoples has using this phpmyadmin to administer their database because it’s easy to use and it help us to reduce the common mistakes. Please follow this step to restore the MySQL database.

1. Go to this url:

    http://localhost/phpmyadmin/

In the real webhosting, “localhost “should be appear as:

    http://myexample.com:2082/cpsess57339117932/3rdparty/phpMyAdmin/index.php


2. Select Import Menu and select file to import.

3. In the previous guideline, we have teach you how to backup the “wordpress_db.sql” mysql database. We will use the same database to restore.

4. Make sure the .sql file has been selected and click go to proceed.
5. If database restoration/import has successful, it will return this such of result

    Import has been successfully finished, 35 queries executed.

6. Please note the above steps are to restore the MySQL only. To migrate the whole blog, make sure you has copy the whole content in “C:\wamp\www\ “. If the folder name was “blog”, make sure you have copy the “C:\wamp\www\blog“.

How to Install WAMP Server on Windows XP or Windows

WAMP SERVER(WampServer) is a great package for PHP developers or maybe students or maybe the newbie system administrators or webmasters. Generally, Wamp Server consist of Apache, MySQL and PHP. In this tutorial, i will guide you how to install the fresh wamp server.

1. Go to this url to download

    http://www.wampserver.com/en/download.php


2. Download the latest WampServer released. At the moment, the newest version was WampServer 2.1a [24/12/10]. It includes :
– Apache 2.2.17
– Php 5.3.3
– Mysql 5.1.53 (version 64 bits)
– Mysql 5.5.8 (version 32 bits)
– PhpMyadmin 3.2.0.1
– SQLBuddy 1.3.2

3. Please take note on this warning.

    WARNING : do not try to install WampServer 2 over WAMP5.
    If WAMP5 is installed on your computer, save your data, uninstall it and
    delete the WAMP5 directory before installing WampServer 2.

4. In your windows workstation, double click the WampServer2.1e-x32 or WampServer2.1d-x64.exe
5. During the installation, it will prompt you to unblock the http server from windows firewall or not. Simply click unblock to allow the Apache running on your local pc.
6. To start the wamp server, click “Start All Services”.

7. To test your wamp server, please go to any browser, type url :

    http://localhost/
    

If the installation successful, it should return the “WAMPSERVER Homepage