How do I export a database from cPanel?
You export a database when you want a backup, for example, or if you want to import it elsewhere. Exporting a database is easy via phpMyAdmin.
Steps
Step 1. Log in to cPanel.
Step 2. Under the 'Databases' category, click 'phpMyAdmin'.
Step 3. In the left menu, click on your cPanel username. You will now see an overview of your databases.
Step 4. Click the database you want to export. Then click on 'Export' at the top.
Step 5. To export all, let 'Quick' be selected under 'Export method'. Click 'Extended' if you only want to export certain tables.
Step 6. Click 'Start' to start export.