Page 1 of 1
big mistake this morning
Posted: Wed Dec 24, 2014 3:17 am
by macelee
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.
Re: big mistake this morning
Posted: Wed Dec 24, 2014 3:28 am
by RBerenguel
macelee 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.
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 lost

Re: big mistake this morning
Posted: Wed Dec 24, 2014 6:50 am
by DrStraw
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.
Re: big mistake this morning
Posted: Wed Dec 24, 2014 7:43 am
by Fedya
Re: big mistake this morning
Posted: Wed Dec 24, 2014 9:16 am
by Bill Spight
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.
Re: big mistake this morning
Posted: Thu Dec 25, 2014 8:08 am
by Krama
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.
Re: big mistake this morning
Posted: Fri Dec 26, 2014 8:52 pm
by MMaestro
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.
explain -.-