How to Export a MySQL Database via PhpMyAdmin

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)