Written by Admin on 2025-05-06

How to Download WordPress Database from WP Admin

WordPress is a popular Content Management System (CMS) used by millions of websites worldwide. As a website owner, you may need to take a backup of your WordPress database for different reasons. For instance, if you want to migrate your website to a new server, you may need your database saved as well. In this article, we will guide you on how to download WordPress database from WP Admin.

There are two ways to download your WordPress database from WP Admin. We will discuss both methods below.

Method 1: Using PHPMyAdmin

PHPMyAdmin is a free tool that allows you to manage your MySQL databases through a web interface. It comes pre-installed with most web hosting services.

1. Login to your WordPress Dashboard.
2. Click on "Tools" from the sidebar and select "Export".
3. Now select the 'Custom' option.
4. Under Tables, select the tables that you want to export.
5. Under "Output," select "Save output to a file."
6. Choose the compression format you want the file to be saved in (gzip, bzip, etc.)
7. Click on the "Go" button to start the Export process.
8. Your browser will start downloading the database dump in a compressed file.

Method 2: Using Plugins

There are several WordPress Plugins available that can help you export your database. Here, we will use the “WP Migrate DB” plugin. This plugin is used to migrate, update, backup, and deploy WordPress websites.

1. Login to your WordPress Dashboard.
2. Click on "Plugins" from the sidebar and select "Add New."
3. Search for “WP Migrate DB” in the search bar.
4. Click on “Install Now” and activate the plugin.
5. Once the plugin is activated, click on "Tools" from the sidebar and select "Migrate DB".
6. You will see an option, "Export to File." Click on the “Export” button.
7. Select the tables you want to export and click on “Export Selected Tables”.
8. Your browser will start downloading the database dump in a compressed file.

Note: While using plugins, avoid installing too many plugins on your site because they can slow down your website’s performance.

Conclusion

Backing up your WordPress database regularly is important to ensure the safety of your website. It can help you to recover your website if something goes wrong in the future. This article has shown you two methods to download WordPress database from WP Admin. Choose the one that works best for you and keep your database safe.