| Author |
Thread |
|
silver
Admin
Japan
12,579 posts
Joined: Feb, 2001
894 hardcore releases
|
 Posted - 2003/10/21 : 15:00:12
Here is a mini log of what happened if your interested.
13:33 GST - The entire HappyHardcore.com member database was overwritten by mistake.
13:35 GST - I figure out what is going wrong and explode with the following remark in the chat room.
http://www.happyhardcore.com/forums/topic.asp?ARCHIVE=&TOPIC_ID=9966
13:36 GMT - HappyHardcore.com goes offline for the first time ever in 4 years.
13:40 GMT - We realize that our backup aint that new, we have two options, perge the database with the backup file and deleting the new accounts we dont have complete data on (1200+) OR attempting a recoverage from the transaction log (which at the time I believe to be impossible due to the nature of the mistake)
13:xx GMT - We start testing a few ideas running a few recovery options.
14:xx GMT - Finally agree upon recovering from the transaction log, but still unsure if it would work.
15:2x GMT - Start to recover from the transation log, process took over 40 mins to complete
16:xx GMT - Query build, backup crappy data in case we have to do a purge anyway. This takes 40 mins as well.
17:xx GMT - Execute the recover and start the new import, import takes 10 mins
18:xx GMT - Start testing all the data in the database to see if there are any problems or if the thing even worked.
18:xx GMT - It worked! Well at least it looks like it did... Grabbed a few regulars in the chat room to help out testing... Pull HappyHardcore.com back online... All say OK.
18:50 GMT - I write this message in the forums.
All in all, we only lost 1 member account (I don't know which one - probally a new one - sorry if it was you!).
Phew... We are all lucky today.
As per usual, please please report any problems in this thread.
__________________________________
it's all hardcore.
Alert moderator 
|
lsd
Starting Member
United Kingdom
14 posts
Joined: Oct, 2003
72 hardcore releases
|
 Posted - 2003/10/21 : 15:14:18
I can't find my camel wheres my camel
/xpl
__________________________________
__________ _ _ __________ _ _ __________ _ _ __________ _ _
Alert moderator
|
djtommyrenegade
Advanced Member
United Kingdom
1,311 posts
Joined: Oct, 2002
|
Posted - 2003/10/21 : 15:50:46
nice work silver :)
djtommyrenegade
check out my record collection at
http://www.geocities.com/djtommyrenegade/records_collection.htm
check out my new website at
http://www.djtommyrenegade.tk
Alert moderator
|
slinkySSential
New Member
United Kingdom
77 posts
Joined: Jan, 2003
|
Posted - 2003/10/21 : 16:18:09
well done, im impressed!
wondered what the
"cannot find page" MSG was all about
Everybody makes mistakes,some ppl learn by them,but others will only learn when they blow their hands off
__________________________________
Everybody makes mistakes,some ppl learn by them,but others will only learn when they blow their hands off
Alert moderator
|
shivymong
Junior Member
United Kingdom
116 posts
Joined: Mar, 2003
|
Posted - 2003/10/21 : 17:13:31
me is impressed too!!!!!!!
dance till your feet drop off to the HaRdCoRe ViBe!
www.kandy-kid-central.8m.com
__________________________________
dance till your feet drop off to the HaRdCoRe ViBe!
www.kandy-kid-central.8m.com
Alert moderator
|
Simon
Advanced Member
Belgium
5,001 posts
Joined: Dec, 2001
|
Posted - 2003/10/21 : 17:57:20
It's always pleasing when ANY computer backup techniques actually work  .
Well done .
___________________________________________________________
Everything is random, your probebly not meant to read this!!!!!!
"In My Sleep I Grind My Teeth"
"TeethGrinder"
"Therapy?"
__________________________________
"...The Outsider"
Alert moderator
|
fazza
Advanced Member
United Kingdom
1,126 posts
Joined: Sep, 2002
|
Posted - 2003/10/21 : 18:38:56
i thought someone had hacked me and change my password coz it wouldnt accept my actual password! phew
john peel is not enough!!
__________________________________
all your base are belong to us.
Alert moderator
|
virus
Advanced Member
Canada
4,346 posts
Joined: May, 2001
716 hardcore releases
|
Posted - 2003/10/21 : 18:48:43
i hope you managed to rescue dj_spex's account!!
___________________________________________
Breakin' Eardrums While I'm Breakin' The Law
__________________________________
My Record Collection Can Beat Up Your Record Collection.
Alert moderator
|
SuperHenke
Senior Member
Sweden
285 posts
Joined: Feb, 2001
|
Posted - 2003/10/21 : 19:09:02
LOL!
I just saw him in the ush chat btw. :)
Alert moderator
|
Sean Apollo
Advanced Member
United States
1,687 posts
Joined: Jul, 2003
143 hardcore releases
|
Posted - 2003/10/21 : 19:17:17
silver good job
---DJApollo---
Direct Drive Productions
Midland, Michigan
One Sexy Dj... : )
"Is this the real life?"
__________________________________
- Sean Apollo
Alert moderator
|
Xenochrome
Advanced Member
United States
2,645 posts
Joined: Aug, 2002
|
Posted - 2003/10/21 : 22:00:29
quote:
Originally posted by virus:
i hope you managed to rescue dj_spex's account!!
Maybe this was all just an elaborate hoax, devised with the sole purpose of getting rid of him...
Great job Silver!!!
__________________________________
Alert moderator
|
Hard2Get
Advanced Member
United Kingdom
12,837 posts
Joined: Jun, 2001
|
Posted - 2003/10/21 : 22:11:22
quote:
Maybe this was all just an elaborate hoax, devised with the sole purpose of getting rid of him...
LOL, i'd be impressed :)
Hehe i never got logged out :)
Alert moderator
Edited by - Hard2Get on 2003/10/21 22:12:14 |
ryg0r
Advanced Member
Australia
2,807 posts
Joined: Aug, 2002
34 hardcore releases
|
Posted - 2003/10/21 : 22:32:56
I didn't quite understand what was happening. One minute I was posting, the next thing, the error.
I was trying to trace the route to the server, but I though a flood of ICMP's is not what you need when you are trying to start up a broken server.
Err, how does one overwritten the member database??
-=[ryg0r]=-
__________________________________
Visit my site at http://commandobot.com/
Alert moderator
|
silver
Admin
Japan
12,579 posts
Joined: Feb, 2001
894 hardcore releases
|
Posted - 2003/10/21 : 22:43:36
I would not really call this recovering from a backup, something happened yesterday that I can't explain and the data magically was recovered I still can't believe I managed to get it back.
It was overwritten because when I was changing something, the server excuted a command that was only half built, the half it did not excute was the half telling it which records to overwrite, without that half it over wrote the entire DB.
__________________________________
it's all hardcore.
Alert moderator
|
milo
Advanced Member
Canada
3,391 posts
Joined: Sep, 2001
347 hardcore releases
|
Posted - 2003/10/22 : 04:18:44
a handy time for the "undo" command...
__________________________________
http://milo.happyhardcore.com
HappyHardcore.com/North American Hardcore Movement/Totally Sweet Radio/Hardcore Street Team
Alert moderator
|
LMPhoenix
New Member
United Kingdom
38 posts
Joined: May, 2002
|
Posted - 2003/10/22 : 05:24:17
/me would like to point out 2 things
Computers dont make mistakes.
People who use computers make mistakes.
Muhahahahahahaha
I Just want you to know its nice to be important but its important to be ****ing nice
__________________________________
I Just want you to know its nice to be important but its important to be ****ing nice
Alert moderator
|
Printer friendly
