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.

READ  How to Install Vim on CentOS 5.8

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

Leave a Reply

Your email address will not be published. Required fields are marked *

SiteGround.com

A world leading hosting company that provides fully-managed innovative and secure solutions, suitable for hosting small to medium-sized websites

Built on the best available technologies combined with Google Cloud for strong redundancy and application availability. Backed by skilled experts to address web security threats, a devops team to create advanced custom security solutions, and 24/7 sysadmins to watch over the platform. This powerful, hands-on approach makes your sites faster, safer, and easier to manage. Starting from only $3.95/mo.

TRY FREE

* up to 30 days money back guarantee