To administer/manage your MySQL database we provide the popular program phpMyAdmin. The program works via a web browser and allows for creating and editing databases and database tables, executing SQL statements and much more.
To use phpMyAdmin, first log in to your cPanel:
Once logged in, towards the bottom of the page click on phpMyAdmin
The phpMyAdmin program will now be shown. On the top left of the page you will see a listing of your MySQL databases. You will also notice a database shown called information_schema. This is a system database and can be ignored. It does not count against your number of databases you are using. To view a database and it's tables and content, click on the database name you wish to view on the top left of the page.
The database will now be shown and you will see a listing of the database tables in the middle of the page.
To browse the fields and records of a table click on the table name under the database name at the top left of the page. The page will be shown as below.
To export/dump/backup a database, click the database name at the top left of the page, then click on Export towards the top middle of the page.
The export page will now be shown. You can leave all the settings as they are for a basic export of your database. Make sure all the tables are selected as you most likely will want to export your entire database including all it's tables. Towards the bottom of the page click on Export. An export of your database in .sql format will now be downloaded to your PC.