Best WordPress Database Backup Plugin

Do you want to know how to make a WordPress database backup using some plugins. There are Free and premium plugins that will help you backup your WordPress database easily within minutes. In this article, we will show you how to make a WordPress database backup using 6 plugins.

When and Why Make a WordPress Database Backup

You should always have a wordpress backup system for your site, as this gives you the option to restore your site if anything goes wrong. Also you should use 3rd party backup solution instead of backup service provided by your hosting provider.

Many users loses their contents and data if their site is hacked or unoperational, in those cases you may need to restore, you can download a new copy of wordpress from wordpress.org but what about your contents and data.You can only have your contents restored only if you have a backup.

You can create backup either by plugins or by using cPanel or do a manual backup. (how-to-make-a-wordpress-database-backup-manually) Having said that, let’s take a look at how to easily make a WordPress database backup manually.

1. BackWPUp

BackWPUp WordPress Database Backup Plugin

BackWPUp is a free that allows you to create complete what is backup not just a database and also allows you to store in your favourite cloud services like Dropbox, Amazon S3, rackspace, FTP, email or even your computer. I have used several wordpress backup plugins but I have to say BackWPUp has got a very clean user interface and it is really simple to use.

If you want to use Google drive as you cloud backup service then BackWPUp has got a premium version that allows you to have the Google Drive feature and restoring  your database is really easy and very simple and hardly takes about 2 minutes.

 

2. WP Database Backup

WP Database Backup - WordPress Database Backup Plugin

WP Database Backup is a free plugin and it helps you easily create WordPress database backups. It allows you to upload your backups to cloud services like Dropbox, Google Drive, Amazon S3, FTP and even email.

WP Database Backup have some great features some of them are like the automated and repeating schedule, option to download the backup file directly from WordPress dashboard, send to multiple cloud servers, search for a particular backup, and is very simple to configure.

At the time of writing this post it has around 60000+ active installs and has a rating of 4.5 out of 5 stars.

 

3. BackupBuddy

backupbuddy-review

The great features of backupbuddy is:

  • It automatically creates regular backup schedule.
  • Backup on your cloud of your choice
  • Comes with one click Restoration and migration for backups
  • And backups all your media files folder and even database

BackupBuddy is a premium plugin that cost around $80 to $297 depending on the licence you choose. We have a dedicated post on how to use BackupBuddy to protect your blog.

 

4. WP-DB-Backup

wp db backup

WP DB Backup is another backup plugin just like WP database backup, and it allows you to easily backup your WordPress database tables and also other tables that are created by some plugins for any other softwares.

At the time of writing this post WP DB backup has 4.5 ratings out of 5 stars and nearly after 400,000+ active installs. The only downside of WP DB Backup is that there is no more documentation pictures for anything else to know how the plugin works.

 

5. WP-DBManager

WP-DBManager - WordPress Database Backup Plugin

As the name suggests WP-DBManager allows you to manage your entire database from one place and its not Just backup WP-DBManager allows you to optimise database, repair your database, backup, restore and also delete database. It also supports other queries like dropping table and running some selected queries on your tables. Like every other backup plugin WP-DBManager also comes with automatic scheduling of backup optimising and repairing databases.

The interfaces of WP-DBManager is really simple and clean it allows you to set the path where you want dump all your MySQL values and the log files and also I allows you for automatic scheduling and allows you to choose the time like week’s, months and years. It also has a great features that most of the bloggers and other website owners would love is the optimisation of your database.

Everyday use of your wordpress will store several files they are not necessary, WP-DBManager really helps you clean all the junk files, delete the old post revision that no longer needed and also some transient values and meta data that have expired or no longer in use.

At the time of writing this post WP-DBManager have a 4.4 rating out of 5 stars and100,000+ active install.

 

6. BackUpWordPress

BackUpWordPress - WordPress Database Backup Plugin

BackUpWordPress not only allows you to create backup for the database but also allows you to create a complete backup of your entire site and even you can schedule the files for a backup. BackUpWordPress is super simple to use and require no setup it is also very low on memory means it will consume less memory and works on shared host like shared hostings.

Some features of BackUpWordPress are like managing multiple schedule, email you when Backup is done and it works on Linux and Windows servers. Option to include exclude files and folders for backup and also it can be translated into several languages.

BackUpWordPress has 4.7 rating out of 5 stars and the total active installs of 200,000+.  Currently BackUpWordPress has got the highest ratings from all the plugins that have been mentioned till now in this article.

 

7. WP Time capsule

wp time capsule

Many startup bloggers and website owners wants to have complete wordpress backup solution for free.  WP Time capsule is not just a simple plugin for backup it is a complete automated incremental backup solution for any wordpress blog and it is absolutely free. Creating a backup for your site is the best thing you can do for yourself  and WP Time capsule help you achieve that.

WP Time capsule supports only three cloud services that are Dropbox, Google Drive and Amazon S3.  To use wp time capsule you have to download the plugin and also have to sign up on the website.We on smart active blogger make use of WP time capsule to have complete backup. We have a complete guide on how to setup your backup using WP time capsule.

Conclusion

Backing Up your site is the best thing you can do for yourself and your site. It gives you a peace of mind and also assures that your blog will never die due to a hacker or some technical problem.That’s all, we hope this article helped you learn how to create a complete backup for your site for free. You may also be interested to know the 9 Best WordPress Plugins For Backup And Restore.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

Do you have experience with any of these? Would you add others to the list? Share your thoughts in the comment section below.

How to Create a Complete WordPress Backup for Free

One of our readers asked us about how she can create a complete WordPress Backup for Free without paying for any services or plugin. So in this article we will show the exact steps you need to follow to create a free WordPress backup for your site.

Important: Many WordPress hosting providers offers backup services for WordPress. Do not rely solely on your hosting provider for backups, instead have your own backup for your site.

Creating a backup for your site is the best thing you can do for yourself. Having a complete backup for your site not only secures your site but is also the best defence against any security threats towards your site or if you mistakenly messed up your site.

In the past we have showed you 9 ways you can have your WordPress site backed up and also mentioned about a premium plugin known as BackupBuddy which can help you create complete automatic backups for your site.

Lets Get Started to Create WordPress Backup for Free

First thing you need to do is install and activate wpTimeCapsule plugin. But only activating the plugin is not enough, you need to have an account on their website wpTimecapsule.com and signup for Free Account by filling the form.

If you want to download your backups to your computer for offline use then our tutorial on how to backup WordPress site to computer will satisfy your needs.

WordPress Backup for Free wp-time-capsule-account-information

 

As you have already activate the plugin in the first step, you need to visit wpTimeCapsule in your wp-admin and select the cloud storage app tab and select the cloud app that you would like to have your backups saved. Click and sign into your account to connect the app.

Creating regular WordPress backups is the best gift you can give yourself and also the best thing you can do for your website. Backups give you a peace of mind and can save you in catastrophic situations when your site gets hacked or you accidentally lock yourself out, or your hosting server gets infected with malware. There are several free and paid backup plugins and websites that There are several free and paid backup plugins and websites that offers seamless backup for WordPress, and most of them are fairly easy to use and comes in Freemium and Pro to provide you access to all that powerful features. In this article, we will show you the best and free way to have automatic incremental backups with wpTimecapsule Incase if you are seeking for a backup plugin then this 7 best backup plugins for WordPress can definitely help you out. Overview - What is WP Time Capsule WP Time Capsule is a free WordPress backup service with a plugin developed by the InfiniteWP team. This plugin does an awesome job on creating incremental backups of your site automatically and stores your wordpress core files, media, uploads and your database in your favourite cloud storage. The options for cloud storage are as follows: Dropbox Google Drive Amazon S3 best wordpress backup plugins You can schedule your backups at any time of your choice, as it happens automatically at your pre-set time. Incremental Backups – How wpTimeCapsule Works? WP Time Capsule is really smart when it comes to create backup of your WordPress site. Its so designed that it will have your entire WordPress site backed up when you run the backup for the first time, and after that it will only update the files and database that have been changed or updated automatically or manually by you. It only updates the changes you make thereafter. The reason behind implementing the incremental backups it to avoid the hiccups that your server and blog gets you you run the backup service. The stress of backing up your entire database and WordPress files over and over again is really tiring and frustrating, and truly speaking I don't enjoy taking daily backups. Backing Up - How To Freely Backup Your Site with wpTimeCapsule [Note: Clicking the below links will take you directly to the selected topic, making it easier to directly visit and read the section you want.] Creating an Account Installing & setting up wpTimeCapsule Scheduling Backups Creating your 1st backup Viewing your activity log Restoring your site 1. Creating an Account This is the first step to get started. Goto WPTimeCapsule.com, and click the Sign Up for Free button. Fill the form with your name, email address and desired password and hit create an account button. wp-time-capsule-account-information It will send an email with a confirmation link, click the link and activate your account. 2. Installing & Setting Up WP Time Capsule In order to have your WordPress backup, wpTimeCapsule requires you to have a plugin installed. To install the WordPress plugin, Log into your WordPress site, and go to the Add a New Plugin page and search for "wpTimeCapsule", Click the Install Now and Active it. how to install wptimecapsule Now head over to wpTimeCapsule.com and select the cloud storage app tab and select the cloud app that you would like to have your backups saved. Click and sign into your account to connect the apps. [Cloud Image] Download this quick printable guide to creating visually appealing content. 3. Scheduling Backups wpTimecapsule start backup process every day at the desired time you have selected. Select the desired time and the time zone city, in case your city is not listed, choose the nearest city or the same city that has the same timezone as you. [Timezone image] The next step is choosing what you want to backup, I recommend you to have a complete backup of your site. Click theFolder & Files option and select all of your files after that click on database and select all the listed checkboxes. You can exclude and file, folder or a database table field if you don't want to have it backup. [database image] If there are any file extensions that you don't want to backup and exclude it to save time and space, enter the in the box. [Exclude image] Click on save and Continue. 4. Creating Your First Backup Here comes the time consuming and lengthy part of backup, which may bore you or slow down the performance of your WordPress site. WP Time Capsule's take first backup syncs all your selected folder, files and database to your selected cloud storage. It creates an initial and complete backup the first time it runs and then only backups any changes made to your site after that. [IMAGE] The backup process is automatically started when you hit the save and Continue button in the previous step. 5. Viewing Your Activity Log To check whether your backup was successful, you can view your activity log by visiting WP Time Capsule > Activity Log. You can check the status , the time it took to complete the backup 6. Restoring Your Site from a Backup The plugin automatically takes daily backup for your site, and each backup creates a restore point. If for any reason your site turns nonoperational, you can restore it to any one of these days using a restore point. [image] Click 1 Restore Point on your most recent restore point to restore your site to the last day it functioned correctly. While restoring you have the option to chosse what you want to restore. Click the list icon to open the selection menu. Only the files that were changed appear in this screen, so you may only find the database and the changed file here. For any reason if you want to restore your site completely, you will need to choose your initial backup as a restore point. Once you have selected everything that you want to restore, click the Restore Selected button or Restore site to this point, if you want to restore every file that was backed up to that day. [IMAGE] A popup will appear asking if you're sure to restore your site. Click Yes to proceed. Which will now present you with a progress bar to let you know how far the restoration has proceeded. You will also receive an automated email from Wp Time Capsule shortly after the restoration begins. Where are Backups Saved? WP Time capsule creates a new folder by its name in the main directory of the selected cloud storage and creates a new folder inside it name "yourdomain.com", which is where your backup is located. The database is backed in a separate folder. If you need access to your database file for a manual restoration, you can access it by visiting your Cloud Storage App > WP Time Capsule > yourdomain.com> Uploads > tCapsule > Backups. Features Website Rollback Backup Before Update One-Click Staging File Change Monitor Final Thoughts Incremental backups, such as the ones ManageWP introduced, are among the lightest ways to back up a WordPress site, and they’re even automatic and daily. Astonishingly, WP Time Capsule has offered all of these features for free. The plugin is also truly lightweight and “set and forget.” You choose when it performs its daily backup, and because it’s incremental, you won’t even know it’s running due to the swift way it creates these backups. You’ll also have access to numerous of restore points, giving you a quick and easy way of repairing your site and getting it back online should a doomsday event occur. You can check out this plugin for free now.

Once you are signed in you the next step you need to do is to select your cloud storage, in this case you will be presented with 3 options i.e Dropbox, Google Drive and Amazon S3.

Select your cloud storage and authorize it to allow the plugin to save its data. Once you have granted all the rights you need to schedule the backups. wpTimecapsule start backup process every day at the desired time you have selected. Select the desired time and the time zone city, in case your city is not listed, choose the nearest city or the same city that has the same timezone as you.

How To Create Automatic WordPress Backups For Free With WP Time Capsule

After you have scheduled the backup time you need to choose what files and folders you want to backup. 

WordPress Backup for Free - WP Time Capsule - Backup - scheduling - initial backup

The fourth tab which says Take First Backup is a time consuming process, here is where everything you have selected in the third tab will be backed up to the cloud storage you selected earlier. The backup process is automatically started when you hit the save and Continue button in the previous step.

Restoring the backups is much simpler, every backup creates a unique restore point for you. A popup will appear asking what you want to restore. Once you have selected everything that you want to restore, click the Restore Selected button or Restore site to this point, if you want to restore every file that was backed up to that day. Thats how you restore and backup your WordPress site for free using wpTimecapsule.

That’s all, we hope this article helped you learn how to create a complete backup for your site for free. You may also be interested to know the 9 Best WordPress Plugins For Backup And Restore and the complete tutorial on creating Automatic Incremental WordPress backups with wpTimeCapsule.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Google+.