1. Login to cPanel and click on phpMyAdmin


2. Select the database which you wish to backup from the drop down database menu at the left.

In this example, I shall pick "joshipro_wptest1".

3. Tick the box for "Check all / Check tables having overhead


3. Click on "Export" tab.

4. Select Export Method and the compression format.


5. Click "Go" to begin the backup download