How do I backup a MySQL database using phpMyAdmin?

Step 1: Login to cPanel
Step 2: From the Databases section, click phpMyAdmin
Step 3: Click the database you wish to export
Step 4: Click the Export tab
Step 5: Click the Custom option under method
Step 6: Under the output section, select the compression type. Please read our section above about using Zip
Step 7: Click Go at the bottom of the page. Now the database will be downloaded