Export MySQL database using phpMyAdmin
Login to your cPanel (e.g. www.yourdomainname.com/cpanel).
Click on “phpMyAdmin” icon at Databases area.
Click on the name of database that you would like to export from the left menu.
Click on “Export” tab.
Select “Custom – display all possible options”.
Click “Select All” and ensure “SQL” format is selected. Choose “Save output to a file”.
Click “Go” button.
Click “Save File” and click “OK” to save the database backup file to your computer.