Schedule Blog Database Backup Files & Data

You cannot always rely on your Web Hosting Company for your Blog’s Data & Files hosted in your hosting account because at times when there is a Hard Drive Failure you can lose everything ranging from your files and the database along with complete emails wiped off which is when its recommended to go for regular backups of your stuff.

Dont worry there is something which you can do yourself without much programming knowledge required and a one time system setup after which you should get scheduled backup files to your emails on assigned intervals. Check out WP-DBManager WordPress plugin which is a Complete Database Manager for your blog. I have installed this on one of my blog in order to give you a idea of how this stuff is installed, activated and run.

Once the Plugin is Activated you will get the following message ‘Your backup folder MIGHT be visible to the public’ , To correct this issue, move the .htaccess file from wp-content/plugins/wp-dbmanager to /home/public_html/wp-content/backup-db and this is mainly a security option which should be performed right away. Once this step is performed you will find a new option on the Admin Menu named as ‘Database’ which you need to click. You will be shown with few database related information in different tables which would include :

Database Information
Database Host
Database Name
Database User
Database Type
Database Version
followed with Tables Information which shows you the total records on your database along with Tables Count and the Total Data Usage. Next you can click on the Optimize DB option in order to perform few tweaks and also setup a schedule to optimize database on a monthly schedule automatically, though this function is similar to what WP Optimize does along with Clean Options Plugin.

Click on Manage Backup DB option followed by DB Options section which would perform the following. WP-DBManager can automatically backup your database after a certain period. There are numerous options offered by this plugin which can help you in automatic backup of files & database on your server and also a copy sent to your email.