My blog-database crashed

Spread the love -

All was going well with my blog but there was something I wanted to do. But I managed to crash my database, I rendered it completely useless. A while ago my photoblog crashed and then I decided to schedule the backup in cron, I took a full backup then I monitored the backup-size and saw it grow so I thought it was fine. But it wasn’t. It was generating rubbish and I lost everything. Luckily I managed to de-rubbish some of the data.

Remember backup my friends! 🙂 Now I’ve managed to reconstruct the latest posts but they are empty, I am searching for buffered and cached data on my server and on search engines…

Thanks Google for buffering my pages! Now I’m using that to recreate the content…


Spread the love -

Øyvind Lasse Høysæter

Born in 1971, fell in love with computing in 1983 because of Sinclair's masterpieces. Continued on the magic surrounding the C64, Amiga and moved to the PC world in 1990. Loves science fiction, programming, astronomy, my family and my job. (developer) :)

4 thoughts on “My blog-database crashed

  • 18 August 2010 at 8:14
    Permalink

    That sucks 🙁
    Hope you can get your stuff back 🙁
    Not sure when I did my latest backup.
    And not sure they are useful to begin with, I don’t trust them 🙂

    Reply
    • 18 August 2010 at 8:45
      Permalink

      Thanks Nicole. 🙂 I’ve managed to retrieve a lot but there is still some missing. Oh well.

      I used the opportunity to change theme. 🙂

      Reply
  • 18 August 2010 at 11:50
    Permalink

    I am really sorry that you are having so much trouble. I always make-up my blog posts on MS Word on my computer, and then copy them over to be published, which allows me to have a copy of everything I have posted. It would still be a major pain to have to repost everything, though.

    Reply
    • 18 August 2010 at 12:05
      Permalink

      Thank you my friend! Having that kind of copy was actually a good idea, a kind of “if all else fail”-system. I was lucky that I had the frame of each post, like date, tags, category, title and comments – it was “just” the content I lost. That is a table in the database on its own so it kind of saved me. I have managed to save almost all posts now.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.