How to Backup/Export MYSQL Database Using phpMyadmin
Login to cPanel and click on phpMyAdmin.
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"
_.
Tick the box for "Check all / Check tables having overhead"
Click on "Export" tab.
Select Export Method and the compression format.
Click "Go" to begin the export or backup download
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"
_.Tick the box for "Check all / Check tables having overhead"
Click on "Export" tab.
Select Export Method and the compression format.
Click "Go" to begin the export or backup download
Updated on: 15/08/2018
Thank you!