If you need to export a phpMyAdmin database on cPanel, simply follow these steps:
- Log in to cPanel and navigate to the Databases section.
- Click on the phpMyAdmin option. This will usually open in a new window.
- Choose the desired database from the list on the left-hand side.
- Click on Export from the top menu.
- Click Go at the bottom of the screen to start the download of the SQL file.
The SQL format is the only file you will need if you are looking to move a database.
That’s it! You have now exported a database SQL file. Simply repeat these steps for any additional exports as required.