How to Export a MySQL Database via PhpMyAdmin
From Acenet Knowledgebase
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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)