You can export your MySQL database to import into another database server or store locally as a backup. Follow these steps to export the MySQL database to a file and download it to your computer.
1.Sign in to phpMyAdmin.
2.On the phpMyAdmin home page, from the menu on the left, select the database you want to export.
3.From the tabs at the top of the page, select Export.
4.Select the format as SQL, and click on Export.
- The database will be exported to the local system in .sql format.
