How to Export a MySQL Database via PhpMyAdmin

From Acenet Knowledgebase
Revision as of 17:22, 7 March 2013 by Docs admin (Talk | contribs) (Created page with "How to Export a MySQL Database via PhpMyAdmin: Example DB name: dave_forum Export: If you would like to export (Database dump as it is called) the MySQL DB 'dave_forum': 1...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

How to Export a MySQL Database via PhpMyAdmin:

Example DB name: dave_forum

Export:

If you would like to export (Database dump as it is called) the MySQL DB 'dave_forum':

1. Login to cPanel

2. Scroll down to PhpMyAdmin, click on it

3. Once PHPMyAdmin loads, on the right side, you will see a list of all of your Databases. Click on the DB'dave_forum'

4. Click "Export" at the top

5. Now select "SQL" as the Format

6. Click "Go"

7. You will be asked where to save the 'dave_forum.sql' file

8. Click save and wait for the DB to finish downloading to your local machine.

Done. Your database has been backed up and dumped to a .sql file (This file now can be imported in to a new/existing MySQL DB if needed)