How to restore a MySQL database from backup
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.