Welcome, Guest. Please login or register.
Did you miss your activation email?
July 02, 2024, 01:59:27 am *

Login with username, password and session length
Pages: 1 2 [3] 4 5
Print
Author Topic: CRASH!  (Read 30046 times)
Hunter
EZ Server GM
Legend
*******
Posts: 8100


EZ Server GM


View Profile
« Reply #30 on: September 02, 2010, 12:47:19 am »

I made a full backup of what we currently have. Then I wiped our current database, and I'm restoring from our 6am backup yesterday (actually, was about 20 hrs ago). If this works, I can put in the inventory table from before the wipe so nobody will lose their items. Same with qglobals table too if thats not screwed up, which holds your flags (CG, FG, 3.0, etc).

Hopefully 6am back up works, then I'll take down the server, put in the inventory, and boot up again.

Hunter
Logged

Hunter - EZ Server GM
tab
Newbie
*
Posts: 4



View Profile
« Reply #31 on: September 02, 2010, 12:50:30 am »

I made a full backup of what we currently have. Then I wiped our current database, and I'm restoring from our 6am backup yesterday (actually, was about 20 hrs ago). If this works, I can put in the inventory table from before the wipe so nobody will lose their items. Same with qglobals table too if thats not screwed up, which holds your flags (CG, FG, 3.0, etc).

Hopefully 6am back up works, then I'll take down the server, put in the inventory, and boot up again.

Hunter

Cool deal, sir.  Thanks for the update!
Logged

Juruumpu - Warrior
Robot Kitten Happy Train
Artimis
Newbie
*
Posts: 2


View Profile
« Reply #32 on: September 02, 2010, 12:50:52 am »

Doh! Finished my new warrior's 3.0s, FG, qvic gear (minus helm, damn you helm!), 6 peices of Tacvi gear, and was just about to take her cute butt into PoD for the 1st time today!

Such is life I suppose Smiley Will get it back.

I will probably be starting a new Qvic guild instance when the servers come back up. If you lost gear and don't need plate legs or helm I will have three spots in my group to bring folks along. As long as you don't mind temporarily being a member of Zerg Force D of course Cheesy Send me a tell! (Try Arees 1st)

This is all assuming Hunters amazingly awesome plan somehow fails, but I have faith that it will not! <3 Hunter

Logged

<The Group>
Arees - Warrior
Letto - Warrior
Artimis - Ranger
Aktaion - Ranger
Apollon - Cleric
Athene - Paladin
(The Support)
Callinheroes - Mage
Splinko - Shaman
Calisto - Druid
Jonat
Newbie
*
Posts: 3


View Profile
« Reply #33 on: September 02, 2010, 12:51:09 am »

<3 u
Logged
Othose
Newbie
*
Posts: 3


View Profile
« Reply #34 on: September 02, 2010, 12:51:20 am »

Hope it works. Thanks for the hard work.. now WORK HARDER......  Tongue
Logged
Lanaki
Newbie
*
Posts: 6


Anyone's house needs burning down?


View Profile
« Reply #35 on: September 02, 2010, 12:51:48 am »

YESS!! there is a god! (Hunter)
 Shocked  Grin
Logged

Lanaki Hawaiian - Palladin
Kanani Hawaiian - Shaman
Majer Payne - Warrior
Aolani Hawaiian - Cleric
Aluana
Newbie
*
Posts: 6


View Profile
« Reply #36 on: September 02, 2010, 12:52:39 am »

@Hunter

You're the Maniacal Technological equivalent to chuck norris.
and that's the truth
Logged
Hunter
EZ Server GM
Legend
*******
Posts: 8100


EZ Server GM


View Profile
« Reply #37 on: September 02, 2010, 12:53:36 am »

SUCCESS!

Backup worked.

I quickly took down the database so I can restore peoples flags and items.

Anyone who created a character after last 6am backup will be completely lost.

Server coming up again soon.

Hunter
Logged

Hunter - EZ Server GM
tab
Newbie
*
Posts: 4



View Profile
« Reply #38 on: September 02, 2010, 12:54:34 am »

Life is awesome.
Logged

Juruumpu - Warrior
Robot Kitten Happy Train
Lored
Jr. Member
**
Posts: 65



View Profile
« Reply #39 on: September 02, 2010, 12:55:42 am »

Actually his idea is very sound imo. He said he was working on LDoN content, which hopefully shouldn't have messed with the inventory table, but I'm kinda sketchy as to whether it messed with the qglobals table or not. Not all too familiar with EQEmu code, but I am familiar with databases. Goodluck with it Hunter!

EDIT: Ooops hit the post button a tad bit late lol. Goodjob though, toobad my character is gone gone gone Sad
« Last Edit: September 02, 2010, 12:57:26 am by Lored » Logged
Artimis
Newbie
*
Posts: 2


View Profile
« Reply #40 on: September 02, 2010, 12:56:15 am »

SUCCESS!

Backup worked.

I quickly took down the database so I can restore peoples flags and items.

Anyone who created a character after last 6am backup will be completely lost.

Server coming up again soon.

Hunter

Hm, I think I love you Hunter. Very nice!
Logged

<The Group>
Arees - Warrior
Letto - Warrior
Artimis - Ranger
Aktaion - Ranger
Apollon - Cleric
Athene - Paladin
(The Support)
Callinheroes - Mage
Splinko - Shaman
Calisto - Druid
Aluana
Newbie
*
Posts: 6


View Profile
« Reply #41 on: September 02, 2010, 12:58:47 am »

Actually his idea is very sound imo. He said he was working on LDoN content, which hopefully shouldn't have messed with the inventory table, but I'm kinda sketchy as to whether it messed with the qglobals table or not. Not all too familiar with EQEmu code, but I am familiar with databases. Goodluck with it Hunter!

EDIT: Ooops hit the post button a tad bit late lol. Goodjob though, toobad my character is gone gone gone Sad
i've got a 21 pally on my box account i've been meaning to level. i'll level it with you back up to 70

-Pweas
-Pwomise
Logged
Lored
Jr. Member
**
Posts: 65



View Profile
« Reply #42 on: September 02, 2010, 01:00:20 am »

Sounds good to me. Gonna try and expedite the process this time and probably going to box two characters to have two 70s this time :-P Thanks Pwease!


Edit: Heh, guess I was 70 when the backup was done. AWESOMENESS! Now I just have a ton of AA's to get Lips sealed
« Last Edit: September 02, 2010, 01:02:59 am by Lored » Logged
Hunter
EZ Server GM
Legend
*******
Posts: 8100


EZ Server GM


View Profile
« Reply #43 on: September 02, 2010, 01:03:27 am »

FIXED!

Only took 1 hr 10 minutes to figure out there was a record in the qglobals table that had a null value on the name field. I know the quest code that did it too when I was creating instances for LDoN, so that wont happen again.

Inventory and Flags should be restored.

Anyone that created a character after the last 6am reboot will be lost cause we reverted back to that backup then restored inventory + flags from before the wipe/fix to figure out the problem.

Keep me posted via email if serious problems.

Hunter
Logged

Hunter - EZ Server GM
Mghargh
Newbie
*
Posts: 11


View Profile
« Reply #44 on: September 02, 2010, 01:04:36 am »

It's UP!!

YEAAAAA!!

Thankee muchly Hunter!

Especially for the O-Dark working!
Logged
Pages: 1 2 [3] 4 5
Print
Jump to:  

Recent

Stats

Members
Stats
  • Total Posts: 65023
  • Total Topics: 5057
  • Online Today: 53
  • Online Ever: 8678
  • (December 19, 2022, 02:32:09 pm)
Users Online
Users: 0
Guests: 79
Total: 79
TinyPortal v1.0 beta 4 © Bloc