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.

  • 17 Users Found This Useful
Was this answer helpful?

Related Articles

Do I use localhost or remotemysqlhost for my mysql connection ?

You can view whether your account is using localhost or remotemysql host in your cPanel...

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.

The command line option from SSH is: mysql -d -p database_name > file.sql. Where...

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...