Export MySQL databases

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. In the Save as file section, check the box.
5. Select Go.

Note: If you're working with a large database or a database with a large number of records in a table, you'll need to use Secure Socket Shell (SSH) to export the database.

More info

• Import SQL files into MySQL databases.
• Visit the phpMyAdmin site to learn more.