Blog database backupIn the digital based world in which we live, if there’s one thing that we can be certain of, it’s that from time to time computers will break and data will be lost. Granted, hardware and memory is becoming ever more secure so information loss no longer happens with quite the same frequency as it did during my days at Psion during the 90s (now that ages me) when I recall people losing their agendas and address books on a fairly regular basis.

Nevertheless, we hold more and more company critical information in digital form on PCs and servers which we would we lost without – as no doubt some of us have already discovered to our cost! :(

Well, in your blog, you have another key business tool whose information needs taking care of, just like any other. For this reason, a word of advice – and one that I give to all of my business blog clients – remember to back up your database on a regular basis. Furthermore, just as you should be doing with the information on your PC, keep a copy yourself rather than solely relying on your host to do it for you.

For WordPress users, there used to be a plugin bundled with the application code but this is no longer the case in recent versions. Luckily, the same WordPress Database Backup plugin has been taken on by Il Filosofo and updated as well. The most recent version has an added feature which is a godsend for someone like me that has good intentions on backups but all too often a memory like a sieve for them – you can set it to automatically create a backup on a regular basis and have it saved or sent to you. Great!

If you prefer not to use a plugin or have a masochistic streak a mile wide in you (or for non WordPress users), then you might find this blow by blow account of how to back up your database in the WordPress Codex to be fun reading.

However you decide to go about it, do remember to do it! Or a least keep a large swear box handy for when something goes wrong.

EDIT: Hat tip to Graham Jones for this: it seems there is a new service called Blog Backup Online from Techrigy which offers automated database backups. Caveat – not tried it yet myself but might be worth a look.

If you enjoyed this post, make sure you subscribe to my RSS feed!

1 Comment 
Tags: , , , , , ,

Recomended Reading:

  1. Basic SEO in Blogs 1: Content, content, content!
  2. WordPress Plugins for business blogs – which to use?
  3. Business Blog Design: Navigation and using your Content
  4. WordPress 2.3, Tagging and SEO
  5. Engage your readers