How to restore mysql database from an sql file

In this guide, I’ll show you how you can restore your database from an sql file using phpMyAdmin. A built in tool which is also installed when you install wampserver.

First of all you must have a .sql file. So if you don’t know how to create one. Then follow this guide.

Execute wampserver from the start menu. Then open up your browser an type in:

http://localhost/phpmyadmin

Create a new database, where you will restore your database. It sounds redundant. But think that the database that you have backup needs a new container for it to be restored.

image

From this page, you click on import.

image

Then choose the sql file and click on go.

image

That’s how you restore a mysql database using phpmyadmin

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s