How do I import a MySQL database?

Portal Home > Knowledgebase > Databases > 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.adollaradayhosting.com.au/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.

Add to Favourites Print this Article

Also Read

I can't log into MySQL from a remote computer using a MySQL admin tool. (Views: 351)

Do I use localhost or remotemysqlhost for my mysql connection? (Views: 322)

How do I create a MySQL database? (Views: 354)

How do I restore a MySQL database? (Views: 359)

What are the Basic Connection Settings for MySQL? (Views: 329)