How do I Scheduled Backup of My WordPress Blog Database?
Are you looking up an Scheduled Backup of My WordPress Blog Database or blog automatically from a repeating schedule? So today’s article is especially dedicated to you.
We know that all the data on our WordPress website is safe, thanks to the database. Whenever we write any posts in our blogs, they are saved in our database. Whenever a visitor accesses a page, then php engine data is displayed by the content of our page, by fetching it from our MySQL database.
If ever there is any problem in our database or it gets corrupted, then it means that we will lose our precious content and all the data. Therefore, it is recommended that if you have any of your sites, then take a regular backup. So if any problems arise, because you have a backup of it, you can do everything as you like. Sometime many of the wordpress users are face security issues and website may be gone. So, backup are necessary to recover you wordpress website.
Both the files + database in WordPress meet all the functions of the site. So in this way we should backup both WordPress files + database. But it is often seen that most errors and threats happen to the database. So in such a way, you can do that, take a backup of both things, files and also the database. But backup the database more frequently. Here I mean to say that if you are taking backups of files once a week, take a backup of the database everyday. Or if you are taking backups of the files once a month, then backup the database every week.
We have already shared articles with you to take full backup (database + files) of the WordPress site. One of those articles is given below, which you must read:
How to Get a Full Backup of Your WordPress Site? (In this article, using a plugin named UpDraft has been explained how you can backup)
To learn about the different methods used for backing, please read our article.
In today’s article we will only talk about the backup of the database. If you are backing up files in another way, and want the database to run automatically according to schedule (Scheduled Backup of My WordPress Blog Database), then this method is great for you. But backup the database more frequently. Here I mean to say that if you are taking backups of files once a week, take a backup of the database everyday. Or if you are taking backups of the files once a month, then backup the database every week.
How to Repeated Scheduler Backups from WP Database Backup?
You have to first install this plugin named WP Database Backup in your WordPress blog. (To learn how to install Plugin, you can read our article: How to install WordPress plugins?)
Some great features of this plugin are:
- One-click backup save and restore
- Store backups in local or cloud drives
- The user interface of this plugin is self-explanatory, and you will learn to use it in just a few seconds. After installing and activating the plugin, you have to go to Tools> WP-DB Backup to use it.
You can also instantly backup by clicking on the option of Create New Database Backup, and as soon as you click on this option, your page loading will go to the state and the entire web page will be unresponsive. So you will have to wait a bit for this process, meaning patience is important.
And as soon as the backup is complete, it will be added to this list and you can download it if you want and can restore it when you need it.
Scheduling Backups (Automatic Backups)
To backups according to the automatic timing, you have to go to the scheduler, then the second of the interface. In this you first need to enable Auto Backup option and then define its frequency. After this you have to click on the “Save Settings” button.
As you can see, I have defined in the screenshot above that this plugin will backup the database of my WordPress blog. Similarly you can choose Hourly, Twice daily, weekly or monthly according to your own by clicking on Scheduler option.
This plugin is a very powerful plugin and offers you many other advanced options. All the options given in the Settings page are explained in the screenshot above.
Similarly, if you want to save backups to cloud drives, you can configure your different cloud drives in the Destination page. For example, if you want your backup automatically saved in Google Drive, then you can configure Google.
You can see that in order to connect Google Drive with this plugin, you have to click on the Access button by saving the client id and client secret by Google Drive. After that, after your complete allowance, your backups will continue to be saved in a Google Drive folder, as you would have configured.
There is also a pro version of this plugin which provides many other features to you. But in the free version, you get most of the features which are necessary to do repeated Scheduled Backup of My WordPress Blog Database.
So let me tell you how did you get this plugin? Which method and which plugins do you use to complete backup, scheduler backups, and database-only backups of your site?