How do I import a MySQL database?

To import a database follow the below steps:

I have a backup of my database that I need to import/transfer to my new account.

- Once you have your .sql file you will need to log into your cPanel at www.yourdomain.com/cpanel 
- Click on 'phpMyAdmin' under the 'Databases' menu
- A drop down of your databases is displayed on the left side of the page, select the database you would like to import to. 
- This will create some tabs at the top of the screen, click on 'SQL'.
- This opens a text box and a file upload option. 
- Click browse on the file upload option and find your .sql file 
- After you have selected the file click GO and it will import your database.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I restore a MySQL database?

To restore a MySQL database please follow the below steps:- Login to your control panel...

I would like to dump the Table Structure for my MySQL Database, but none of the data.

There are two ways to do this, one being using phpMyAdmin the other is via SSH. Using...

I can't log into MySQL from a remote computer using a MySQL admin tool.

To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such...

What are the Basic Connection Settings for MySQL?

There are two different ways to connect to a MySQL database: Locally - from a script on the...

How do I create a MySQL backup?

There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel...

Powered by WHMCompleteSolution