Dismiss Notice
Alien Soup is a free community for fans of science-fiction, horror, & fantasy! Everybody is welcome here.

Major SQL crash!

Discussion in 'Announcements and News' started by Kevin, Dec 20, 2007.

Tags:
  1. Kevin

    Kevin Code Monkey Staff Abductee

    Joined:
    Mar 20, 2004
    Location:
    Pennsylvania
    This week we have suffered a major setback in that our MySQL database became corrupted. After many attempts at repairing the 'post' table it was lost cause. Switching to Plan B of restoring from an automated backup did not work either as we found out that the automated backup files have not been good for quite some time.

    No way of repairing the current table and no valid backups led to the worst case scenario of having to start again with a blank slate. Years of work gone in a matter of days. Our exclusive interviews, our years of local posts... gone. :cry:

    It's all... gone. :cry:

    I can only hope that our many community members who have helped make Cool Sci-Fi such a friendly community these past few years stay with us and help us to rebuild in this time despair.
     
  2. 7of9 or Deanna

    7of9 or Deanna Cadet

    Joined:
    Dec 8, 2007
    Hi I have only been on the site for a few weeks and can only imagine how devestated you must all feel. You have worked so hard for everyone. Thank you for now and the future
    Brian
     
  3. Tim

    Tim Creative Writer

    Joined:
    Jan 16, 2005
    Location:
    England
    If any of the featured interview peoples kept a copy of the full thread, please contact me to put back. In the meantime I will be checking google cached pages.
     
  4. sideshowspacegirl

    sideshowspacegirl Have you taken your meds?

    Kevin, I truly feel your loss. :cry:
    But this was a good site and will be again!
    Maybe it's a good thing that everything got lost. This starts the new year with a clean slate.
    Maybe? :(

    Thank you for trying so hard to find everything and for building such a good site!
    Thank you for all your hard work.
     
  5. Kevin

    Kevin Code Monkey Staff Abductee

    Joined:
    Mar 20, 2004
    Location:
    Pennsylvania
    Thanks for the positive thoughts, everybody.

    I admit... I was a mental mess the other day when I realized that we had to start over again with a clean slate but as SideShowSpaceGirl says, this might actually turn out to be a good thing in the long run. The worst part was trying to explain to the Mrs. what occurred but since she isn't a forum user I got the "I-feel-sorry-for-you-but-I-have-no-idea-what-you're-talking-about!" type response.

    I've been exploring new backup solutions to prevent this from ever occurring again as well going over what exactly went wrong so the mistakes of the past aren't repeated.
     
  6. Kevin

    Kevin Code Monkey Staff Abductee

    Joined:
    Mar 20, 2004
    Location:
    Pennsylvania
    Well, after the second SQL crash in as many days we are (hopefully) back up again.

    The past couple of days have been spent backing up everything on the server (FTP'ing 50 gigs over a DSL connection is not as fun as it may sound) and exploring a few different automated backup solutions. Assuming that nothing breaks today then tonight the first automated backups will start kicking in.

    I have also removed some vBulletin add-ons that would've affect performance when viewing the forum posts. The forums are the heart of Cool Sci-Fi so anything that might affect them will either be disabled or removed.

    Cross your fingers, and let's see how Recovery Round #2 goes.
     
  7. Tom

    Tom An Old Friend

    Joined:
    Dec 6, 2004
    Location:
    Gulf Coast
    I have faith in you!
     
  8. Kevin

    Kevin Code Monkey Staff Abductee

    Joined:
    Mar 20, 2004
    Location:
    Pennsylvania
    Well, this weekends lesson learned the hard way is that hammering away at the server with massive SFTP transfers can bring it to it's knees.

    The secondary lesson learned is that there is a ton of stuff on the hard drive that should be cleaned up & removed. :eek: Looks like I'll have to bring out the ruler and hit a few knuckles with it.
     
  9. Kevin

    Kevin Code Monkey Staff Abductee

    Joined:
    Mar 20, 2004
    Location:
    Pennsylvania
  10. Black Mathias

    Black Mathias Twisted Mentat

    Joined:
    Jun 5, 2007
    Location:
    Under the Sea
    Glad to see that everything seems to be up and working again. I guess I'll have to start a new music thread!
     

Share This Page