Log into your cPanel account.
In the
Databasesection, click onphpMyAdminicon.
In the left side-bar, click on the
Expandbutton to expand the database like “example”.
Under your cPanel username, you can see a list of all databases. Select the appropriate database which you want to export to your PC.

click on the
Exportbutton.
Select SQL format and then click on the
Gobutton.
Normal sized SQL files should download within a few seconds however larger files may need more time.