ElePHPant Haven
Scared of the Peacock Revolution since 2006
Blog » Oops
Oops
Posted by Simon Welsh | 15 February 2010 | Comments (2)
I did a really big boo-boo. Like, a really massive one. It was bad. Luckily I had a 2 day old backup so not all was lost.
mysql> UPDATE Book SET Amount = 1, ISBN = '9780863430282';
Query OK, 4359 rows affected (0.33 sec)
Rows matched: 4359 Changed: 4359 Warnings: 0
Share on FaceBook
Trackbacks
None
Trackback URL: http://simon.geek.nz/Trackbacks/add/1206
Post your comment
Comments
-
Thanks to Red and http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html, all is restored :)
Posted by Simon Welsh, 16/02/2010 11:11am (2 years ago)
-
sdkfjh lkf dkjfh
Posted by simon, 16/02/2010 11:10am (2 years ago)
RSS feed for comments on this page | RSS feed for all comments
Twitter Status
Bible Verse
1 Chronicles 5:18
The sons of Reuben, and the Gadites, and half the tribe of Manasseh, of valiant men, men able to bear buckler and sword, and to shoot with bow, and skilful in war, were four and forty thousand seven hundred and threescore, that went out to the war.
Blog Archive
- 2012 (4)
- 2011 (28)
- 2010 (106)
- December (1)
- November (12)
- Where's Wally?
- Geek Day 10 - Picture, screenshot and specifications of your primary computer.
- Geek Day 9 - What OS/distribution do you run?
- Geek Day 8 - Preferred method of communication with humans
- Geek Day 7 - Preferred smartphone platform. And which do you use?
- Geek Day 6 - Primary geek fuel (snacks/drinks)
- Geek Day 5 - Quick nifty hacks you're proud of
- Geek Day 4 - Greatest application written to date
- Geek Day 3 - What does your day job involve?
- Geek Day 2 - Preferred programming language?
- Geek Day 1 - Why do you consider yourself a geek?
- New 30 day thingy
- October (13)
- Day 30 - Your favourite song
- Day 29 - In this past month, what have you learned
- Day 28 - A picture of you last year and now, how have you changed since then?
- Day 27 - Why are you doing this 30 day challenge
- Day 26 - What you think about your friends
- Day 25 - What I would find in your bag
- Day 24 - A letter to your parents
- Day 23 - Something you crave for a lot
- Day 22 - What makes you different from everyone else
- Day 21 - A picture of something that makes you happy
- Day 20 - Someone you see yourself marrying/being with in the future
- Day 19 - Nicknames you have; why do you have them
- Day 18 - Plans/dreams/goals you have
- September (22)
- Day 17 - Someone you would want to switch lives with for one day and why
- Day 16 - Another picture of yourself
- Day 15 - Put your iPod on shuffle: First 10 songs that play
- Day 14 - A picture of you and your family
- Day 13 - A letter to someone who has hurt you recently
- Day 12 - How you found out about Blogger and why you made one
- Day 11 - Another picture of you and your friends
- Day 10 - Songs you listen to when you are Happy, Sad, Bored, Hyped, Mad
- Day 9 - Something you're proud of in the past few days
- Day 8 - Short term goals for this month and why
- Day 7 - A picture of someone/something that has the biggest impact on you
- Day 6 - Favourite super hero and why
- Day 5 - A picture of somewhere you've been to
- To my friends
- Using SilverStripe without the CMS, at all
- Day 4 - A habit that you wish you didn't have
- Day 3 - A picture of you and your friends
- Day 2 - The meaning behind your Blog name
- Tweet buttons!
- Day 1 - A recent picture of you and 15 interesting facts about yourself
- 30 Days of Me
- CMS-less SilverStripe install
- August (6)
- July (8)
- June (10)
- May (6)
- April (2)
- March (7)
- February (9)
- January (10)
- 2009 (77)
- 2008 (86)
- 2007 (40)
- 2006 (16)
Powered by SilverStripe. Hosted by RimuHosting.
Unlease otherwise stated, all content is licenced under a Creative Commons Attribution-ShareAlike Licence.