If you need to export a database in phpMyAdmin, you can do this by following these steps:
- Log in to your cPanel account and navigate to the Databases section.
- Click on the phpMyAdmin option. This will open in a new tab.
- From the left-hand menu, click on the database name you wish to export.
- When the database has loaded, click on Export from the top menu.
- Select the format you wish to export the file in, this is SQL by default and click Go.
That’s it. Your database will be downloaded.