Difference between revisions of "How to Import a MySQL Database via PHpMyAdmin"

From Acenet Knowledgebase
Jump to: navigation, search
(Created page with "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...")
 
 
Line 1: Line 1:
 
How to Import a MySQL Database via PHpMyAdmin:
 
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:
+
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
 
1. Login to cPanel
Line 18: Line 18:
  
 
8. Scroll down and click "Go"
 
8. Scroll down and click "Go"
 +
 +
Allow the upload to complete and then you should be all set! You just restored a MySQL Database!

Latest revision as of 17:25, 7 March 2013

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!