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?
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.
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.
Step 3: From the BlogVault dashboard, select Backups. This will take you to a page where WordPress backups are stored.
Step 4: On the backup page, there is an option called Download. Select it.
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.
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.)
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.
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.
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.
Step 5: After exporting, download the database by clicking on Download ‘yoursite’.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.
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.
Step 3: On the top of the window, you should be able to see an Import and Export option. Select Export.
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.
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.
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)
✔️Enclose table and column names with backquotes (Protects column and table names formed with special characters or keywords)
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.
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. As you continue to upgrade your website with the new themes and plugins, your WP database will grow and become clunky. To learn more about options to speed up your database, check this article team at wpDataTables made