MySQL: Restore Database from Backup using phpMyAdmin.

You may have been working on your blog or website in your local development computer for some time. Now, you think it's time to go online. You have a database backup file which you have created using phpMyAdmin, and you want to know how to import the backup file to your production server.

From time to time, we need to create database backups, transfer them from local to production server or from production to local server, and restore them.

To know how to create a MySQL Database backup using phpMyAdmin, visit the link below.

Create a MySQL Database backup using phpMyAdmin.

 

In this tutorial, you will see how to restore a MySQL database using phpMyAdmin.

The steps:

1) Browse to the phpMyAdmin page from where you manage your databases. If your web hosting company provides cPanel, you can access phpMyAdmin using it.

 

2) Click “Databases” and choose the database into which you want to import the backup.

If your database backup file is meant to be imported into a blank database, create a new blank database, and select this newly created database.

In this tutorial, we created a new database named “db_new”.

create a blank database to import/restore from backup

 

Note: The import will be done on the currently selected database, ff the backup file does not contain any SQL statements to select a database.

 

3) Click on “Import”. In the “File to Import” section, hit the “Browse” button and choose your backup file.

If the backup file is small you can remove the tick in the “Partial Import” section.

Leave the other fields at their default values.

restore database settings in phpmyadmin

 

4) Now, hit on the “Go” button and wait for a while. If everything goes well, you will see the message “Import has been successfully finished”.

database has been successfully imported

 

Congratulations, your MySQL database has been restored.




You might want to contribute to Qoncious.com:




Latest Videos