{"id":5324,"date":"2009-08-21T12:00:02","date_gmt":"2009-08-21T12:00:02","guid":{"rendered":"https:\/\/www.amitbhawani.com\/blog\/?p=5324"},"modified":"2009-08-20T15:01:51","modified_gmt":"2009-08-20T15:01:51","slug":"schedule-blog-database-backup-files-data","status":"publish","type":"post","link":"https:\/\/www.amitbhawani.com\/blog\/schedule-blog-database-backup-files-data\/","title":{"rendered":"Schedule Blog Database Backup Files & Data"},"content":{"rendered":"

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.<\/p>\n

\"Blog<\/a>
Blog Backup Schedule<\/figcaption><\/figure>\n

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<\/a> 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.<\/p>\n

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 :
\n

\"Wp
Wp Database Backup<\/figcaption><\/figure>Database Information<\/strong>
\nDatabase Host
\nDatabase Name
\nDatabase User
\nDatabase Type
\nDatabase Version
\nfollowed 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<\/a> does along with Clean Options Plugin<\/a>.<\/p>\n

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.<\/p>\n

\"Automatic
Automatic Blog Backups<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":5327,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[376],"tags":[],"class_list":{"0":"post-5324","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"entry"},"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2009\/08\/Blog-Backup-Schedule.jpg?fit=%2C&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1482,"url":"https:\/\/www.amitbhawani.com\/blog\/backup-blogs-email-computer\/","url_meta":{"origin":5324,"position":0},"title":"How to Schedule Backup Blogs to Email\/Computer","author":"Amit Bhawani","date":"September 25, 2008","format":false,"excerpt":"Its very good that you have started blogging and have started making money online but taking a backup of all your data is very important as much as is the promotion of your blog. Generally most people neglect this part when they are into serious blogging and when problems like\u2026","rel":"","context":"In "How to Guide"","block_context":{"text":"How to Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/how-to\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6376,"url":"https:\/\/www.amitbhawani.com\/blog\/wordpress-blog-backup-plugins-tools-tutorials\/","url_meta":{"origin":5324,"position":1},"title":"WordPress Blog Backup Plugins Tools & Tutorials","author":"Amit Bhawani","date":"October 12, 2009","format":false,"excerpt":"You have been blogging from a long period and you have been making thousands of dollars from your blog but what about the security of your this money making machine? Iam not taking about any other security but the important content you have written everyday, the thousands of comments you\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Wordpress-Backup-Tools-Plugins.jpg?fit=500%2C275&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":15933,"url":"https:\/\/www.amitbhawani.com\/blog\/automatic-data-backup-software-windows-doublesafety\/","url_meta":{"origin":5324,"position":2},"title":"Best Automatic Data Backup software for Windows – DoubleSafety","author":"Amit Bhawani","date":"October 26, 2010","format":false,"excerpt":"For a computer user loosing all the important files and folders can be the worst thing happening and its always essential to make sure that you have a backup of your data on a external drive. There are many different Online Backup services which can host your data for free\u2026","rel":"","context":"In "Software Reviews"","block_context":{"text":"Software Reviews","link":"https:\/\/www.amitbhawani.com\/blog\/category\/software\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/DoubleSafety-New-Job-Wizard.png?fit=501%2C387&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3757,"url":"https:\/\/www.amitbhawani.com\/blog\/move-wordpress-blog\/","url_meta":{"origin":5324,"position":3},"title":"How to Transfer a WordPress Blog from One Host to Another","author":"Amit Bhawani","date":"May 11, 2009","format":false,"excerpt":"Do you want to Transfer a Wordpress based blog from one web hosting company to another one? Then you might find this tutorial helpful because we are going to actually transfer a website and recommend you the most important steps which should be taken care of while moving the website.\u2026","rel":"","context":"In "How to Guide"","block_context":{"text":"How to Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/how-to\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1792,"url":"https:\/\/www.amitbhawani.com\/blog\/reinstall-wordpress-checkrepair-database-tutorial\/","url_meta":{"origin":5324,"position":4},"title":"Reinstall WordPress Check\/Repair Database Tutorial","author":"Amit Bhawani","date":"October 20, 2008","format":false,"excerpt":"Do you feel that database your blog is running on is corrupted and cannot be fixed? The best option to make sure that your database is working perfectly is to check out the database and then repair if it you find any problems in it. You can use these options\u2026","rel":"","context":"In "Wordpress Guide"","block_context":{"text":"Wordpress Guide","link":"https:\/\/www.amitbhawani.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"Export Wordpress Posts","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/Images\/E\/Export-Wordpress-Posts.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":459,"url":"https:\/\/www.amitbhawani.com\/blog\/best-online-automatic-data-backup-tools\/","url_meta":{"origin":5324,"position":5},"title":"Best Online Automatic Data Backup Tools","author":"Amit Bhawani","date":"May 12, 2008","format":false,"excerpt":"Data Backup is very important in todays world because the data stored on your computer is very important and its very hard to recover it in case of corrupted files which may be formed due to bad clusters in your FAT\/NTFS File system There are several services available which can\u2026","rel":"","context":"In "Hard Drives"","block_context":{"text":"Hard Drives","link":"https:\/\/www.amitbhawani.com\/blog\/category\/hard-drives\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.amitbhawani.com\/blog\/wp-content\/uploads\/2010\/12\/Backup-Online-Data-Tools.png?fit=408%2C233&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/5324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/comments?post=5324"}],"version-history":[{"count":0,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/posts\/5324\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media\/5327"}],"wp:attachment":[{"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/media?parent=5324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/categories?post=5324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amitbhawani.com\/blog\/wp-json\/wp\/v2\/tags?post=5324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}