big mistake this morning
-
macelee
- Lives in sente
- Posts: 928
- Joined: Mon Dec 31, 2012 1:46 pm
- Rank: 5 dan
- GD Posts: 0
- KGS: macelee
- Location: UK
- Has thanked: 72 times
- Been thanked: 480 times
- Contact:
big mistake this morning
I woke up early. Not fully awake I decided to make an update to the Go4Go database. Without following my normal safe procedure I decided to work directly on the database with SQL. A minute later, I realised that I have wiped out an entire field of Go4Go database. It took me two hours to restore the data. A nice exercise for Christmas.
-
RBerenguel
- Gosei
- Posts: 1585
- Joined: Fri Nov 18, 2011 11:44 am
- Rank: KGS 5k
- GD Posts: 0
- KGS: RBerenguel
- Tygem: rberenguel
- Wbaduk: JohnKeats
- Kaya handle: RBerenguel
- Online playing schedule: KGS on Saturday I use to be online, but I can be if needed from 20-23 GMT+1
- Location: Barcelona, Spain (GMT+1)
- Has thanked: 576 times
- Been thanked: 298 times
- Contact:
Re: big mistake this morning
It's so easy to feel secure on doing "always the same"! At least you could restore it without problems... Even if it was 2 hours lostmacelee wrote:I woke up early. Not fully awake I decided to make an update to the Go4Go database. Without following my normal safe procedure I decided to work directly on the database with SQL. A minute later, I realised that I have wiped out an entire field of Go4Go database. It took me two hours to restore the data. A nice exercise for Christmas.
Geek of all trades, master of none: the motto for my blog mostlymaths.net
-
DrStraw
- Oza
- Posts: 2180
- Joined: Tue Apr 27, 2010 4:09 am
- Rank: AGA 5d
- GD Posts: 4312
- Online playing schedule: Every tenth February 29th from 20:00-20:01 (if time permits)
- Location: ʍoquıɐɹ ǝɥʇ ɹǝʌo 'ǝɹǝɥʍǝɯos
- Has thanked: 237 times
- Been thanked: 662 times
- Contact:
Re: big mistake this morning
Don't feel bad. Back in the days when I was a manager of database administration one of the people working for me needed to delete an obsolete test database. Unfortunately he the made the mistake of not checking. He was in the live production database when he executed the command. All work came to a halt while we restored from the backup and rolled in the journal file transactions. No data was lost, but over a hour's production was lost.
Still officially AGA 5d but I play so irregularly these days that I am probably only 3d or 4d over the board (but hopefully still 5d in terms of knowledge, theory and the ability to contribute).
-
Bill Spight
- Honinbo
- Posts: 10905
- Joined: Wed Apr 21, 2010 1:24 pm
- Has thanked: 3651 times
- Been thanked: 3373 times
Re: big mistake this morning
I am reminded of a story from back in the days when a bank manager sent a plaintive letter to Byte magazine -- not much email back then -- asking, "What is the source code and how do we break it?" According to the story a database manager of a large firm was fired. Angry, he made this parting shot. He left the data in the database unchanged. He just deleted all the pointers.
The Adkins Principle:
At some point, doesn't thinking have to go on?
— Winona Adkins
Visualize whirled peas.
Everything with love. Stay safe.
At some point, doesn't thinking have to go on?
— Winona Adkins
Visualize whirled peas.
Everything with love. Stay safe.
-
Krama
- Lives in gote
- Posts: 436
- Joined: Mon Jan 06, 2014 3:46 am
- Rank: KGS 5 kyu
- GD Posts: 0
- Has thanked: 1 time
- Been thanked: 38 times
Re: big mistake this morning
If you are reading this, you have been in a coma for almost 10 years. We are trying this new technique but we don't know where this message will end up in your dream. We just hope you will somehow get it. Please wake up.
-
MMaestro
- Dies in gote
- Posts: 43
- Joined: Tue Sep 20, 2011 12:19 am
- Rank: AGA 3D
- GD Posts: 0
- KGS: 2D
- Tygem: 6D
- Been thanked: 16 times
Re: big mistake this morning
explain -.-Krama wrote:If you are reading this, you have been in a coma for almost 10 years. We are trying this new technique but we don't know where this message will end up in your dream. We just hope you will somehow get it. Please wake up.