Have you backed up your blog today?

Hosting Matters had another hardware failure on the server that hosts blogHOUSTON a few days ago.

As a result of their dead hard drive and one faulty backup, they had to restore an older backup, and a few days' worth of data was lost.

Since that's the second time such data loss has happened, that meant it was time to investigate backup solutions (and maybe, eventually, a new host), so that I'll have some confidence in having a backup no more than 24 hours old if things crash again. Of course, playing with scripts takes away from posting time at a time when travel, work, and Cougar athletics events are all keeping me occupied, but hey -- stuff happens, and rarely happens at convenient times.

As it turns out, this guy has a very helpful page for people who run sites powered by mySQL databases and want a fairly automated backup system. I was able to modify his script to back up two databases (the weblog and the forum) each day via a cron job, and to email the files to a gmail account set up specifically for that purpose. So that *should* ensure that I always have a backup no older than 24 hours. Maybe. Like I said, stuff sometimes happens.

Posted by Kevin Whited @ 12/29/07 22:14 | Tech | Technorati

Previous Entry | Home | Next Entry


TrackBack

There are currently no trackbacks for this item.

Incoming trackback pings have been disabled because of abusive spammers. Technorati is now used to track cross-blog conversation.



Comments

No comments yet. Add yours?


Add Comments

While it is not required, creating an account for commenting provides a number of benefits (such as comment editing and bypassing the captcha challenge). You may log in to your account here.

No flames or impolite behavior. Any questions, see the site policies. Older posts are moderated (because of spammers), so if your post does not appear immediately, that could be why.

HTML will be stripped. URLs will be transformed into hyperlinks.

[b]text[/b] will produce bold text. [i]text[/i] will produce italicized text.

:

:
:



Comments for this post must be approved before being published. Thank you!

SITE MENU

» Weblog
» About Me
» Archives
» Disclaimer
» Flickr Gallery
» Syndication

BLOG

» Create Account
» Log In


DISCLAIMER

Content and design copyright © 1997-2008, Kevin Whited.

Posts represent the views of Kevin Whited (and occasional guest bloggers) only, and do not necessarily reflect the views of employers, family, friends, or significant others.