Author Topic: Start Here!  (Read 38829 times)

Psidefect

  • Administrator
  • Hero Member
  • *****
  • Posts: 3,633
  • Karma: +161/-155
    • Bizarre Confessions
Start Here!
« on: December 29, 2006, 09:43:38 AM »
Ok, the second try at rebuilding the db didn't go so well.

The backup is huge and I'm having problems getting it to the new host in a form that will work for the import.

The real problem is that I don't have enough time to deal with this right this moment, so I set up this board in the mean time.

SMF is the board software that I wanted to migrate BC to anyway, so it seemed like a good choice. At least this way we'll all have a place to yap while I figure out wtf is up with the db backups. I'm pretty sure I have all the data and that it's just a matter of getting it to the new host, so don't panic about something being lost. I should have it, it just might be hard to get to it for a little while.

Anyway, SMF seems much better than phpbb at first glance, but I want to hear feedback from you guys. Do you like it, not like it, wish it had a certain feature? Let me know.

Right now the board is as vanilla as they come. It's all public and it's just one category right now. I'll try to stop in during the day and make some of the obvious changes as I can carve out time, but bear with me (ladies, feel free to bare with me!). Hopefully we'll have everything back to normal as soon as possible.

Thanks and enjoy!
- Psi
“You've got a lot to learn about screwing up your life, pal.” - mrcookieface
“How sad for a marriage to fail because it's not compatible with Windows 31!  But it'll happen.” - random axe
“Not my problem if they don't know how to make magic smoke out of it.” - Stormy
“Dude. That will get you out of TWO family holidaycausts.” - Stoatse
"It is my role in this drama to misunderstand things at top volume." - Hmof

bit zero

  • Trusted
  • Sr. Member
  • ****
  • Posts: 381
  • Karma: +91/-7
  • come and see the violence inherent in the sysadmin
    • Meh
Re: Start Here!
« Reply #1 on: December 29, 2006, 12:48:16 PM »
What format is the backup in now?  What format do they want it in?

I think a mysqldump file will load into things like phpMyAdmin...  well, except for php not accepting an upload that large :)

Psidefect

  • Administrator
  • Hero Member
  • *****
  • Posts: 3,633
  • Karma: +161/-155
    • Bizarre Confessions
Re: Start Here!
« Reply #2 on: December 29, 2006, 01:08:14 PM »
It's all in mysql dump format (text sql inserts). The problem isn't the format, it's the fact that it's too large to upload without phpMyAdmin timing out. I've asked the guys at the new host to import it, but it seems to be incomplete when they do.

I think I can break it into smaller chunks, but that will take some time. I have the big tables broken down into single query files, but they're still a meg or so and the timeout still happens. They are complex queries though and could probably be broken down into smaller pieces. I won't know for sure until I have more time to spend on it.

Anyway, the data is still there. I have a lot of backups and I can still make them if I need to (the db is still up on the old server). It should just be a matter of when I'll be able to get the data back into the board.
“You've got a lot to learn about screwing up your life, pal.” - mrcookieface
“How sad for a marriage to fail because it's not compatible with Windows 31!  But it'll happen.” - random axe
“Not my problem if they don't know how to make magic smoke out of it.” - Stormy
“Dude. That will get you out of TWO family holidaycausts.” - Stoatse
"It is my role in this drama to misunderstand things at top volume." - Hmof

bit zero

  • Trusted
  • Sr. Member
  • ****
  • Posts: 381
  • Karma: +91/-7
  • come and see the violence inherent in the sysadmin
    • Meh
Re: Start Here!
« Reply #3 on: December 29, 2006, 01:19:38 PM »
php's default upload size is 8 MB, I think, so maybe something like "split -l 500" would get it into 8 MB chunks?

(Hm.  My copy of phpMyAdmin defaults to 2 MB.  Yeah, remind me not to import my 20 GB database that way.)

DM

  • Trusted
  • Hero Member
  • *****
  • Posts: 675
  • Karma: +84/-24
  • DM Here
    • Dangermonk.com
Re: Start Here!
« Reply #4 on: December 29, 2006, 01:31:19 PM »
It doesn't take that long to break a database into smaller chunks.  The biggest problem I've had with it is naming the files.  Of course, I'm an idiot.

Psidefect

  • Administrator
  • Hero Member
  • *****
  • Posts: 3,633
  • Karma: +161/-155
    • Bizarre Confessions
Re: Start Here!
« Reply #5 on: December 29, 2006, 03:02:56 PM »
Well, the breaking it down into chunks itself doesn't take much time (they're splittable anywhere between queries), but some of the 1Mb files are a single query.

Breaking that down into smaller chunks is what will take some time.

It's not phpMyAdmin's limit I'm hitting, it's the php script timeout limit on the server.

...uh, DM, why don't you just number the files (eg: filename01.sql, filename02.sql, etc)?
“You've got a lot to learn about screwing up your life, pal.” - mrcookieface
“How sad for a marriage to fail because it's not compatible with Windows 31!  But it'll happen.” - random axe
“Not my problem if they don't know how to make magic smoke out of it.” - Stormy
“Dude. That will get you out of TWO family holidaycausts.” - Stoatse
"It is my role in this drama to misunderstand things at top volume." - Hmof

DM

  • Trusted
  • Hero Member
  • *****
  • Posts: 675
  • Karma: +84/-24
  • DM Here
    • Dangermonk.com
Re: Start Here!
« Reply #6 on: December 29, 2006, 03:15:35 PM »
The timeout thing.  Blah...

I did number them.  That was giving me problems.   Yeah...  I know.

Dr. Leonard HmofCoy

  • I'm a doctor, not a bricklayer!
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 19,673
  • Karma: +205/-69
  • His BRAIN is gone
Re: Start Here!
« Reply #7 on: December 29, 2006, 09:55:08 PM »
I fucking lied on the TOS, Defect. I intend to post offensive and defamatory material, fyi.

*lowers pants*

*moons forum, boils and all*

P.S. Thanks!
"Parasitic wasps laying eggs in other insects is a better love story than Twilight." - :bitzero:
"Anyhow, it was the best sentient food movie since Killer Tomatoes Eat France." - :flipper:
"lee marvin in drag is no way to spread the gospel, son." - TFJ
"It failed. My enemies have been purged." - Sidious
"It's not like there was ever a time I didn't think Rudy Giuliani was a smug gibbering imbecile." - random axe
"*drags taint* Oh cool, I didn't know you could do that." - mo.d

Hussein

  • Newbie
  • *
  • Posts: 8
  • Karma: +75/-7
Re: Start Here!
« Reply #8 on: December 29, 2006, 09:57:27 PM »
I think you and I should have a beer together while there is still time.

DM

  • Trusted
  • Hero Member
  • *****
  • Posts: 675
  • Karma: +84/-24
  • DM Here
    • Dangermonk.com
Re: Start Here!
« Reply #9 on: December 29, 2006, 10:01:50 PM »
Fuck.  He's not dead yet?

BizB

  • Administrator
  • Hero Member
  • *****
  • Posts: 1,239
  • Karma: +103/-16
  • HURRRRRRRRRR
Re: Start Here!
« Reply #10 on: December 29, 2006, 10:28:40 PM »
I like it.

We need Karma here.
I overslept this morning.  I was hitting the snooze button like it was my little sister.
I overslept this morning.  I was banging the snooze button like it was my step sister.

Stoater

  • Guest
Re: Start Here!
« Reply #11 on: December 30, 2006, 06:48:16 AM »
I fucking lied on the TOS, Defect. I intend to post offensive and defamatory material, fyi.


What he said.

Stoater

  • Guest
Re: Start Here!
« Reply #12 on: December 30, 2006, 06:52:03 AM »
You should probably "sticky" this particular topic there, froot loop.

Mr. Hate!

  • Trusted
  • Full Member
  • ***
  • Posts: 143
  • Karma: +83/-28
  • Gort is my copilot
Re: Start Here!
« Reply #13 on: December 30, 2006, 10:11:22 AM »
WTF is up with those verification letters images that are so tiny and obscured that you can't read them? And no, I'm NOT gonna listen to the letters. That's as bad as tasting the rainbow. Whatever that means.

Tripper

  • Trusted
  • Hero Member
  • *****
  • Posts: 944
  • Karma: +84/-21
  • Go ahead, make my millennium
    • Benson-Photo
Re: Start Here!
« Reply #14 on: December 30, 2006, 11:42:14 AM »
Look!  (shows poopie diaper)

(runs)