BackupBuddy: How to Restore Your WordPress Database

BackupBuddy: How to Restore Your WordPress Database

It goes without saying that every single website needs a backup. And many freelancers and web designers are even using backups as an additional revenue stream for their businesses. iThemes revolutionized the industry when we created BackupBuddy and we have made restoring backups to a WordPress site even simpler.

BackupBuddy has the capability of restoring WordPress sites directly within WordPress. This also applies to restoring your database as well, so in this post, we will cover how to restore your database backup. First, the only thing you will need is a full backup or a database only backup. BackupBuddy will be able to restore SQL tables from either type of backup.

Let’s Begin Restoring Your Site

The first step to restoring your WordPress database, you will want to head over to the Backups page and click the Restore Backup tab.

Next, pick the backup you wish to restore the database with. In this case, we will restore the database from a full backup. Click the Restore button adjacent to the Restore Files button, and you can choose what you wish to restore from this full backup.

BackupBuddy: How to Restore Your WordPress Database 1

On this step, make sure to click the “Database Only” option. Then verify you wish to restore the database by checking the verification box. BackupBuddy will now begin restoring your WordPress database. You can navigate away from this tab and work on other projects, or you could always stay on the page and view the restoration process.

At this point, BackupBuddy will begin creating temporary tables in the database and then will proceed to dump rows into these temporary tables. When this is complete, it will replace these tables with the tables that correspond to your table’s prefixes.

Note: this process may take some time depending on how many tables

Your WordPress Database Restored

Upon restoring your WordPress site, you may encounter that you need to sign back into your admin account. This is normal, and not to be concerned about. This is due to being logged in with another session whenever the backup was made initially. It will



This article was written by Tyler Gilbert and originally published on WordPress News and Updates from iThemes – iThemes.

Disclosure: Some of the links in this post are "affiliate links." This means if you click on the link and purchase the product, We may receive an affiliate commission.

Leave a Comment

Your email address will not be published. Required fields are marked *

Show Your ❤️ Love! Like Us
Scroll to Top