Export a database with phpMyAdmin

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

Follow these steps:

  • Log in to the included phpMyAdmin application.

  • Select the application database in the left navigation menu. In this example, the database is named bitnami_wordpress.

  • Select the “Export” menu item.

    Database export

  • On the resulting page, select the “Quick” export method and the “SQL” output format.

  • Click “Go”.

    Database export

An SQL export file will be created and downloaded to your desktop. Store this file carefully, as you will need it if you plan to later import the database back into MySQL.

Last modification September 28, 2021