Order Now
Home>Encyclopedia>Video Tutorials>MySQL>How to restore a MySQL database
Advanched MySQL Database Management Tools

How to restore a MySQL database from backup

Domains and Subdomains Video Tutorials



Our Most Popular Hosting Plans



Budget Hosting

Value Hosting

Plus Hosting

Exclusive Hosting
Budget Hosting - $4.95 per month Value Hosting - $7.95 per month Plus Hosting - $9.95 per month Exclusive Hosting - $14.95 per month
Unlimited Space Unlimited Space Unlimited Space Unlimited Space
Unlimited Traffic Unlimited Traffic Unlimited Traffic Unlimited Traffic
1 Domains Unlimited Domains Unlimited Domains Unlimited Domains
FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *		 FREE Domain
Registration/Transfer *
Order Joomla Web Hosting
Order eLearning Web Hosting
Order WordPress Web Hosting
Order 4images Web Hosting

How to restore a MySQL database from backup - overview


Here is an overview of the three simple steps you need to go through:

1. First, you need to log into your Web Hosting Control Panel. To do that, go to the Control Panel login link in the upper right corner of the NTC Hosting's website. Then enter your personal web hosting account details in the Members Area Login form and click the Log-in button to log in.

2. Once in the Control Panel you need to login into the MySQL Databases section. To do that, click the 'MySQL Databases' located in the Site Management section of the Web Hosting Control Panel.

3. To proceed with restoring a database from backup, you need to open the phpMyAdmin tool, by clicking the name of a database or its corresponding phpMyAdmin icon.

3.1. Once in the phpMyAdmin interface, select the name of the database, which you want to restore from backup from the Database drop-down menu.

Then press the SQL tab from the main menu.

3.2. In the SQL tab you should browse for the dump file using the 'Browse' button under 'Location of the text file'. When you find your dump file hit the 'Open' button.

3.3. As soon as the dump file has been selected, hit the 'GO' to import your database back-up file. After the import operation is completed - open the 'Structure' tab from the main menu. There you'll see a full list of your database tables added to your account so far. 

3.4. Scroll down to find the one you have just restored from backup successfully.

You have just learnt how to restore a database from a dump file through the phpMyAdmin tool.