WP-DB-Backup, as the name implies, backs up your database, not your files. The plugin allows you easily to backup your core WordPress database tables. You may also backup other tables in the same database. This can be a good option for those who don’t update their sites very often or who don’t use images in their blog posts. You can schedule database backups, restore from backups, and it even offers a way to perform a manual database backup just in case you can’t get into phpMyAdmin. This article shows steps to backup WordPress with WP-DB-Backup plugin.
Features of WP-DB-Backup Plugin
- Backup automatically on a repeating schedule
- Download backup file direct from your WordPress Dashboard to your computer
- WP-DB-Backup is user friendly with simple configuration settings
- Email notification to manage your backup files
- Backup your entire site database
- Exclude some specific files you want to in your backup
Backup WordPress with WP-DB-Backup Plugin
Step 1. Install and Activate Plugin
In the first step, installing “WP-DB-Backup Plugin” can be done searching for “WP-DB-Backup” via “WordPress Dashboard > Plugins > Add New” as shown below.
Step 2. Backup WordPress with WP-DB-Backup
After installing the plugin, go to Dashboard > Tools > Backups and click on the Backups tab. You will see the plugin Backups page in your screen as shown below.
You will see a list of tables to back up in the screen. On the left side, all of your core WordPress tables are listed. On the right, is any optional tables available such as those associated with plugins. Select them all if you want to do a full backup.
Down to the bottom of the page, there are two options to download the database backup to your computer or to email the backup to your mailing address. When having the database backup emailed or sent to your browser for immediate download, the backup file will be deleted from the server when the transfer is finished. Only if you select delivery method “Save to server” will the backup file remain on your server.
Once you have the options selected that you want to use, click “Backup Now!” button. WP-DB-Backup will then begin with the backup process. When the process of backing up is running, you will see a progress bar in your screen. Once complete, it will send an email or simply store the database backup to your computer depending on the options you have chosen previously. I have chose the backup to your computer option here.
After the completion of the backing up process a Pop-Up box appears automatically in your screen which helps you to download the GZIP file in the Downloads folder in your Computer. Select the Save File option and click on OK button to start the download.
When the GZIP file is completely downloaded go to Computer > Local Disk (C:) > Users > PC Name > Downloads and you will see your Database backup .gz file in the Downloads folder in your computer.
WP-DB-Backup Plugin also provides solutions to schedule backups. You may schedule backups hourly, daily, or weekly. I recommend keeping them weekly instead of daily unless you make changes to your site on a daily basis. I also recommend never selecting the hourly function unless you are on a dedicated server as it will certainly increase your server loads.
Once your settings are complete, you’ll see a line at the top of the Scheduled Backup section telling you when your next backup will be performed. Now all you have to do is file the weekly emails and manage your database backups.
WP-DB-Backup Plugin is relatively easy to set up, and does work with most hosting providers. However it’s limitations are that it only backs up the database, rather than the entire site, and sometimes it struggles with larger databases.