Hello guys,
This post will help you out to export a MySQL Database using phpMyAdmin. Follow the following steps.
1. Login to cPanel.
2. Locate and click on the "phpMyAdmin" icon under the "Databases" category.
3. After entered into phpMyAdmin, select a database that you wish to export from the list on the left side of screen.
4. Click on the "Export" tab and select an export option:
Quick - Export the entire database using the default options.
Custom - Select specific tables within the database to export, or change the individual export options.
5. Click on the "Go" button and the database export will begin.