Exporting a database via phpMyAdmin using cPanel
To export your database, you’ll need to open your databases via phpMyAdmin first.
On phpMyAdmin choose database and press Export:
If you want to easily export to SQL file (SQL file is everything you want when moving databases), just click on Go:
Also, if you would like to set special requirements, you can change the format or choose to export only some tables from your database:
That’s it! Once you click Go a copy of your database will be downloaded to your computer