Author Topic: Forum Downtime  (Read 4384 times)

0 Members and 1 Guest are viewing this topic.

Offline EBE@RTF

  • Team Leader - Australia
  • Administrator
  • Challenge Mode
  • ******
  • Posts: 2954
  • Rating: +14/-2
  • Gender: Male
  • Gigantic Ska Robot
    • Team RTF Australia
Forum Downtime
« on: July 23, 2008, 01:23:27 AM »
Just a quick note to explain the downtime over the last couple of days.

I attempted to update the forum software to fix a few bugs we were encountering, primarily with the Karma function. In the process of doing this, I had created a full backup of the forum database before wiping it from the server.

This is when I found out that the database import function in myPHPAdmin limits files to 2MB, and the forum db has now grown to 3.5MB.

A lot of stuffing around later, it turns out the backup wasn't in the file format it said it was, and I had to use a utility from the SMF forums to restore the db. But we're back, and that's the important thing.

Sorry for any problems this cause people, especially with organising this weekend's get together.
Team Ranking Task-Force
Part of Australia's DDR community since 1999

Offline moose!

  • Get a clue, moron
  • RTF Team Member
  • Challenge Mode
  • *****
  • Posts: 1786
  • Rating: +15/-1
  • Gender: Male
Re: Forum Downtime
« Reply #1 on: July 23, 2008, 07:30:43 AM »
fail ebe is fail

importing a db into phpmyadmin is limited to 2mb? whaaaaaaaaat...fail
i lol'd
go sex up a tree

Offline EBE@RTF

  • Team Leader - Australia
  • Administrator
  • Challenge Mode
  • ******
  • Posts: 2954
  • Rating: +14/-2
  • Gender: Male
  • Gigantic Ska Robot
    • Team RTF Australia
Re: Forum Downtime
« Reply #2 on: July 23, 2008, 12:54:11 PM »
Apparently that's pretty common. So common in fact that someone on the SMF forums wrote a utility to import db files via PHP.

Unfortunately, that import doesn't properly support Japanese text by the look of it, so what little discussion there was in that forum had to be junked.

What is also apparently common is the issue I had where the forum says it's outputting a compressed gzip file, but instead it gives you a plain text .sql file with a .sql.gz filename :/

These issues combined to stump both me and the tech, but now, thanks to me and the SMF forums, we're back on top of it.
Team Ranking Task-Force
Part of Australia's DDR community since 1999

Offline Gurt

  • Team Doorknob
  • RTF Team Member
  • Challenge Mode
  • *****
  • Posts: 3636
  • Rating: +13/-0
  • Gender: Male
  • LET'S GURT IT ON
    • Neon Pixel Nightmare
Re: Forum Downtime
« Reply #3 on: July 23, 2008, 09:30:54 PM »
I hate PHP for so many reasons!

Offline Squidgy

  • NSFW
  • Challenge Mode
  • *****
  • Posts: 730
  • Rating: +6/-0
  • Gender: Male
Re: Forum Downtime
« Reply #4 on: July 24, 2008, 10:14:27 AM »
And here was me looking forward to postcount++ing for a few days on a fresh forum board. :P Wipe everything anyway if you ask me! Do we still all want to go watch something this weekend?

Offline EBE@RTF

  • Team Leader - Australia
  • Administrator
  • Challenge Mode
  • ******
  • Posts: 2954
  • Rating: +14/-2
  • Gender: Male
  • Gigantic Ska Robot
    • Team RTF Australia
Re: Forum Downtime
« Reply #5 on: July 24, 2008, 12:59:38 PM »
Do we still all want to go watch something this weekend?

Yes we do!

Appropriate thread is appropriate.
Team Ranking Task-Force
Part of Australia's DDR community since 1999