There are often times where you may need to export a database via the phpMyAdmin interface in cPanel. This can be achieved very easily using a couple simple steps:
1. Login to cPanel and click phpMyAdmin under DATABASES.
2. Click on the database you want to export and then click Button at the Top that says Export. Note: If this is a WordPress site you can usually find the database name within your wp-config.php file.
3. Click Go to generate a .sql file of your database. This is all that is needed in most cases.
Though the quick export option is all that is needed in most cases, if you did want to export specific tables you can select Custom for export method and check the boxes next to each table that you want to export.