How to Export a MySQL Database via PhpMyAdmin
From Acenet Knowledgebase
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)
