The WordPress database is where you store crucial website information including posts, pages, users, et al. Every time you add a new user, publish a new post, database stores the information. Without the database, WordPress websites will display only a white screen. Since the database is critical to your WordPress website, it is advisable to save it. There are many ways to export WordPress database safely. In this post, we’ll show you how to export the database to your local computer. Once you have the copy with you, store the copy of the database on Google Drive or Dropbox. There are two methods that we can use to export the database on our local system

How to Export Database Safely?

1. Export WordPress database using a plugin

2. Export WordPress database manually from phpMyAdmin

Method 1: Export WordPress database using a plugin

In this method, we are going to use two WordPress plugins – BlogVault and All-in-One WP Migration to export your database.

Exporting database using BlogVault Backup Services

Step 1: Sign up with BlogVault backup service and set up an account.

Now to set up a BlogVault account, you will first have to Add a Website (the same website whose database you want to download). Then configure the BlogVault plugin.

add site to blogvault

Add site and then plugin

Note:

When you Add a Site to the BlogVault dashboard, the service immediately syncs with your website and takes a backup. You can easily download the database from this backup. How? Let’s find out.

Step 2: Open your  BlogVault account, select the website you just added in the previous step. It’ll take you to the BlogVault dashboard.

sites on blogvault dashboard

Select a site

Step 3: From the BlogVault dashboard, select Backups. This will take you to a page where WordPress backups are stored.

select backups

Select the Backups option

Step 4: On the backup page, there is an option called Download. Select it.

click here to download database

Select the Downloads option

Step 5: On the download page, there is an option called Selective Download. Expand it by clicking on the + sign. It’ll ask you What to Download. Select Database (as shown in the picture below). Then hit Continue.

download wordpress database

Select Database

It’ll take a few minutes for the database to be ready. Once it’s ready, click on the Download Link and the WordPress database backup will be downloaded into your local system or computer. (There are options to customs export. Meaning you can deselect whatever WordPress database table you don’t want to export.)

click database download link

Click on the Download Link

That’s it. Your WordPress database export is complete. BlogVault is a paid tool. It’s primarily a backup service. We strongly advise website owners to be responsible and use reliable backup services, but if they are only interested in exporting their database, then they could probably use the other alternative. All-in-One WP Migration is a free migration plugin that’ll help you export the database. Let’s take a look at how to use All-in-One WP Migration.

Exporting database using All-in-One WP Migration

Step 1: Log into your website’s admin. Go to Plugins and choose Add New. It’ll take you to a page from where you can add a new plugin.

add new wordpress plugin option

Select Add New

Step 2: In the Add Plugins page,  there is a search option on the right. Search for All-in-One WP Migration. All-in-one WP Migration will be displayed in the search results. Install it and then Activate the plugin.

click install all in one wp migration plugin

Search for the plugin

Step 3: After installing and activating, the All-in-One WP Migration plugin should appear on the left-hand panel of the dashboard. If you hover your cursor over the plugin, a menu opens up. You can see the Export and Import options. Select Export from the menu.

Step 4: On the Export page, click on Export to and then select File.

export database with all in one wp migration

Select File

Step 5: After exporting, download the database by clicking on Download ‘yoursite’.com.

click here to download database of your site

Click on Download westworlddaily.com

Exporting database using backup plugins are a safe option. You don’t need to access the database manually so there’s no risk of making a mistake. But for website owners who don’t want to add more plugins to their site, you can export the database. Needless to say, you need to cautious.

Method 2: Export WordPress database manually from phpMyAdmin

Exporting the database manually is relatively simple for someone who is WordPress-savvy. But for a novice WordPress user, we’d recommend accessing the database under supervision. Manually exporting databases in WordPress requires you to access it through your web host account.

Step 1: Log into your current hosting provider. On the cPanel/ control panel dashboard, there is a section called Database. From this section, select phpMyAdmin.

choose phpmyadmin database

Select phpMyAdmin

Step 2: In the phpMyAdmin page, you will see a vertical list of MySQL databases on the left side. Select the database you want to export. We selected bhwpsite_67e. As soon as you select the specific database, it’ll expand and show us the SQL tables under the database.

phpmyadmin treeview from database

Select the database

Step 3: On the top of the window, you should be able to see an Import and Export option. Select Export.

export wordpress database from phpmyadmin

Select the Export option

Step 4: There are a few things we need to do on the Export page.

i) First off, there are two Export methods. One is Quick – display only minimal options and the second is Custom – display all possible options. Select the second method, i.e. Custom – display all possible options.

custom export database radio button

Select the Custom export method

Note: Older version of phpMyAdmin may not have two methods. In that case, the default method is ‘Custom’ which is fine in any case.

ii) After selecting Custom, Tables of the database appear. Choose Select All.

iii) And from the Format section, select SQL.

export database tables in sql format

Select all tables and SQL format

iv) Scroll down the page and select the following options from the section Object Creation Options:

✔️Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement (If you decide to upload the database to a new site, this option will help you replace the existing Database table of the same name. But if you plan to merge this database with the database of the new site, then do not select this option.)

✔️Add CREATE TABLE statement IF NOT EXISTS (less efficient as indexes will be generated during table creation)

✔️AUTO_INCREMENT value

✔️Enclose table and column names with backquotes (Protects column and table names formed with special characters or keywords)

object creation options in phpmyadmin

Select these options in your File Manager

Step 5: Next, scroll to the bottom of the page and select Go. The database will begin downloading. Generally, the downloaded file is available in the Download folder of your computer, unless you have changed the destination folder.

Conclusion

With that, we come to the end of how to manually export the database of WordPress sites. You can upload the database with services like Dropbox or Google Drive. Also, you can even use the database to move WordPress from localhost to server. Let us know if you found the guide useful. For more WordPress tutorials check our blog.