Announcement

Collapse
No announcement yet.

Our database barfed - lost some posts, sorry!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Our database barfed - lost some posts, sorry!

    Gang,
    During the past week we encoutered a few database errors which resulted in the loss of some posts and threads, including the popular "Where to buy one" thread that I started waaaaaay back when we first put this site up on the Internet last fall. Sorry about that. We try to keep everything running smoothly but Mr. Murphy strikes every now and again...

  • #2
    Re: Our database barfed - lost some posts, sorry!

    Originally posted by John Mitton View Post
    We try to keep everything running smoothly but Mr. Murphy strikes every now and again...
    cron a nightly db backup overwriting the previous one and you would, at most, only lose ~24hr.



    --edit: It would appear that you do not have the option of cron'ing backup ...

    http://forums.westhost.com/showthread.php?t=10956
    Last edited by jblue; 05-30-2008, 12:10 PM.


    ?Innovation is driven by having access to things.? -- Gleb Budman, CEO of backblaze.com

    Comment


    • #3
      Re: Our database barfed - lost some posts, sorry!

      Originally posted by jblue View Post
      cron a nightly db backup overwriting the previous one and you would, at most, only lose ~24hr.



      --edit: It would appear that you do not have the option of cron'ing backup ...

      http://forums.westhost.com/showthread.php?t=10956
      or just dump it nightly maybe rotating 3 or 4 files.
      The nightly backup will bkup the dump. We did this on Sybase.

      You will need cron or a substitute to automate the process.

      This is for MySQL but the idea is the same for most RDBs.

      http://www.base64.co.uk/mysql-dump-backup/
      CH

      Comment

      Working...
      X