How do I restore the file into the MySQL database?

Follow the steps above until you reach the phpMyAdmin window. Open the .sql file that you have saved using either Notepad or Wordpad. Select All then Copy and Paste it into the box labelled "Run SQL query/queries on database" in phpMyAdmin. Hit "GO" button. This should recreate the tables as it was in your Database.

  • 33 Users Found This Useful
Was this answer helpful?

Related Articles

What is MySQL?

MySQL is a fast, easy-to-use, multi-user SQL (Standard Query Language)...

How can I create databases?

You can create MySQL databases easily using your Control Panel. Please follow our flash tutorials...

How many databases can I create?

The number of databases you can create depends on what Hosting Plan you have....

How do I manage my Database?

Every account we have has a phpMyAdmin pre-installed and can be accessed...

How can I back-up my database?

Log-in to your Server Administrator, then click on Databases. Select the...

Powered by WHMCompleteSolution