Access your site’s database

You can use phpMyAdmin to access your website’s database and run a wide range of operations. This guide will show you how to administer your site’s MySQL database.

This feature is available on sites with the WordPress.com Business and Commerce plans, and the legacy Pro plan. If you have a Business plan, make sure to activate it. For sites on the Free, Personal, and Premium plans, upgrade your plan to access this feature.

Database management is an advanced task and should only be performed by users with experience in MySQL. Most site owners will never need to access their database directly. Do not make changes unless you have a clear, specific reason to do so.

If you’re unsure what a command does, do not run it. Executing unfamiliar commands can break your site or result in data loss. Always test any database changes on a staging site first.

Before accessing your database, consider contacting a Happiness Engineer. We’re happy to help determine whether database access is necessary and may be able to suggest safer alternatives. However, we are unable to assist with creating, modifying, running, or debugging database commands.

If you experience issues after making database changes, you can restore your site from a backup.

Each WordPress.com site comes with a single, pre-configured database. It is not possible to create additional databases, connect your site to a different database, or access the database externally.

To access your site’s database, follow these steps:

1. Visit your Sites page: https://wordpress.com/sites/
2. Click the ⋮ next to your site and select the Settings tab.
3. Scroll down to the Server section and click the Database option.
4. Click the “Open phpMyAdmin” button. A new tab will open. If you are not redirected automatically, click the provided link to access your database in phpMyAdmin.

You can also access your database through WP-CLI.

PhpMyAdmin is a tool used to access your site’s database and run commands to interact with it. For help with using phpMyAdmin, you can consult the phpMyAdmin documentation.

You can also use phpMyAdmin to upload .sql files and import database content.

Keep in mind that the size of the database counts against your plan’s storage limit. File size limits and max execution time are set on the server side and cannot be changed.

To export a copy of your database, you can download it from your site’s backups:

1. Visit your site’s dashboard and navigate to Jetpack → Backup.
2. Choose the backup you want.
3. Click the down arrow on the “Restore to this point” button or click the Actions button:

4. Click the “Download backup” option.
5. On the following screen, uncheck all options except “Site database”.
6. Click “Create downloadable file“.