Export a database via phpMyAdmin
How to export a database using phpMyAdmin?
Sometimes when you want to make some changes to the database associated with your website it is advisable to create a backup. To do so you need to export the database and save a copy on your local computer so in case that something goes wrong you can restore the application to its working condition.
To do so you first need to go to your cPanel.
Next go to the phpMyAdmin tool which is available under the Databases section:

Find your database in the list on the left side of your screen and click on it. This will display all tables of the database:

Now go to the Export section, select Quick export method, set the export format to SQL and click Go:

The SQL file will be downloaded on your local computer.