How to export (dump) your WordPress database

You will need to know:

  • your sFTP username and password – check the Control Panel
  • your Database Admin URL – check the Control Panel
  • your database username and password – this can be found in your site’s wp-config.php file – use sFTP to access your site, download the wp-config.php and open it in an editor – the following lines contain the information you need:

define(‘DB_USER’, ‘username‘);

define(‘DB_PASSWORD’, ‘password‘);

If you need help locating your login credentials, watch this video:

How to Dump your Database:

  1. Login to your Database Admin using your database username and password.
  2. After logging in, click on Dump.
  3. At the Dump screen select ‘Save’ as the output type, double check that all other options match the screenshot below and then click “Export”.
  4. Copy the downloaded .sql file somewhere for safe keeping