If you own a WordPress website, there is a possibility that at some point you’d want to move the site to a different location. Such a move involves exporting and importing website database which can be a fairly complex process, one that is prone to mistakes. It can lead to grave consequences like broken websites. In this article, we’ll guide you on how to export WordPress database on your own without breaking your website.
This guide is about exporting the WordPress database from your previous host. If you are trying to move your website to a new domain or hosting provider, then you should check out our WordPress Migration service.
What is a WordPress Database?
A WordPress website contains data. Posts, comments, settings, and users are data stored in the WordPress databases. It can be described as a storehouse where you can organize and maintain your information. Without the database, your website will appear as a blank page. Or it may throw an error saying ‘error establishing a database connection’. When you are performing a database export, it is advisable to tread carefully.
How to Export WordPress Database Safely?
You can export your database manually or using a plugin. Using a WordPress export plugin is a safer option. But nonetheless, we’ll guide you through both the methods.
Method 1: Export WordPress Database Using a Plugin
There are many WordPress plugins that’ll enable you to export database. But we’ve chosen the following 5 because they are easy to use –
- WP Database Backup
- WP Remote
- All-in-One WP Migration
- Import Export WordPress Users (for exporting only users)
Install and activate the WordPress plugin. BlogVault will immediately take a backup of your website including the database. BlogVault will notify you after the backup process is complete. After which you can proceed to export the database.
On the BlogVault dashboard, there’s a section called Backups. Click on Backups.
On the next page, you’ll notice 5 options at the top of the page. Select the fourth one that’ll help you Download Backups. Don’t worry. You don’t have to download the entire backup. BlogVault gives you an option to download the database only on the next page.
Now, you should be able to see an option called Selective Download. In it, you’ll have the option to download only the database.
That’s it. You have downloaded the database to your local computer.
2. WP Database Backup
It’s a WordPress database backup plugin. Install and activate it on your WordPress blog. After installing, navigate to Tools > WP-DB Backup to access the plugin. It’ll prompt you to take a backup of your database by selecting Create New Database Backup. Go ahead and click on the button.
Once the backup files are ready, just select Download to export the database to your computer.
3. WP Remote
WP Remote is a website management plugin. It enables you to export a copy of your database to your computer. Create an account, add your website to WP Remote and then activate the plugin. From the WP Remote dashboard, select Download Database. It’ll export the database to your local system.
4. All-in-One WP Migration
With the WP Migrate tool, you can export your WordPress theme and plugin, media uploads as well as the database.
Install and activate the plugin on your website. From your dashboard, navigate to All-in-One WP Migration and select Export. Instead of making the default choice to export WordPress website as a whole, choose only the database. Simply select all the Advance options except Database. Next, go over to Expand To and select File and you are done.
5. Import Export WordPress Users
Designed for WooCommerce websites, the plugin helps export and import user data. It’s easily one of our top choices for WooCommerce plugins.
Install and activate the plugin on your website. It’ll add functionality to your website, enabling you to export user databases. On your WordPress dashboard, navigate to Users > User Import Export > User/Customer Export. The plugin also gives you an option to choose which WordPress user roles you want to export.
Assuming that you are migrating users to a different WooCommerce site, you can easily import WordPress users with the same plugin. Just install the Import and Export User plugin into your new website. And when you are ready, go to Tools > Users > User Import Export > User/Customer Import. And that’s it.
The process of exporting the database with a plugin is easy. But if you’d prefer doing it manually, proceed to the next section.Exporting the WordPress database is a daunting task for many people. But with a proper guide, you can't go wrong. Click To Tweet
Method 2: Export WordPress Database Manually
Before you begin…take a backup
Take a fresh backup of your website. The manual export method involves taking steps that are risky. If you make mistakes, the backup will help you restore your website back to normal.
1. Exporting Database in FlyWheel
Hosting providers allow you to export your database. But the process differs from web host to web host. For instance, in FlyWheel, you need to login. Then navigate to Advanced > Database > Manage Database > Export.
2. Exporting Database in Bluehost
In Bluehost, the process is a bit different. To access your database, you need to log into your hosting account. Then navigate to phpMyadmin to find the Export option.
After you select Export, it will reveal two options – Quick & Custom (see the image below).
To export your entire database, choose Quick. But if you want to export only specific tables, then selecting Custom export is a better option.
Depending on the size of your website, it’ll take a few minutes to export the database.
Like Bluehost, most WordPress hosting providers allow users to export the database from phpMyadmin. You can do a quick Google search to find out how your hosting providers enable you to download WordPress database.
Note: Your database holds crucial information which should be protected from being corrupted. Our suggestion would be to store the database safely in cloud services like Google Drive or Dropbox instead of keeping it on your computer.
We started the article by pointing out how you may need to move your website to a different location for which you need to export the database. Exporting your database is a pretty straightforward process. But if you are trying to move your website to a new location, you may run into some issues like:
- Unsupported web hosts
- Downtime for large sites
- Incomplete Migrations
If you are a BlogVault client, you’ll most likely never have to worry about these. We support over 5000 hosting services and we promise zero downtime because we place a minimal load on your site, so there’s no risk of crashing it. We perform a complete migration so you don’t have to worry about broken links or missing pages. Plus, exporting a database with BlogVault is easy and hassle-free.
Try out BlogVault’s expert WordPress Migration