Here are the steps to export database table via phpMyAdmin in cPanel:

Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area.

In the Databases section, click on phpMyAdmin Icon.



Under your cPanel username, you can see a list of all databases. Please select an appropriate database which you want to export it to your PC.



Click on the Export button.



Select SQL format and then click on the Go button.

SQL file will be downloaded within a few seconds, but If a size is large, then it will take a long time.

Updated on: 14/02/2023