How to Import a MySQL Database via PHpMyAdmin

From Acenet Knowledgebase
Jump to: navigation, search

How to Import a MySQL Database via PHpMyAdmin:

If you would like to import the 'dave_forum.sql' file in to a newly created MySQL DB, then follow the steps below:

1. Login to cPanel

2. Scroll down to PHPMyAdmin, click on it

3. Once PHPMyAdmin loads, click on the database (The one you just created) in question on the right hand side

4. Click "Import" at the top

5. Now click "Browse"

6. Select your 'dave_forum.sql' mysql db backup

7. Make sure the "Format" selected is "SQL"

8. Scroll down and click "Go"

Allow the upload to complete and then you should be all set! You just restored a MySQL Database!