Wednesday, 6 April 2011
Sorry to all of time?
I did something incredibly stupid this morning.
I was editing the database to correct an error and executed a query that updated all the comments, since the beginning of the blog, to the phrase, "Only a WFRP 2e refugee is mad enough."
Nothing like seeing Query returned successfully: 98 rows affected, 67 ms execution time. appear in your window to wake you up.
I think I have a backup, but not a recent one. Indeed. "Only a WFRP 2e refugee is mad enough" to edit the production database!
Update
I have been able to recover all but the most recent comments. Crafting the UPDATE command now.
Update #2
I have restored all comments (going back 5 years!). To Jen and Teri, visitors from the A to Z challenge, apologies! I guess "history will show" that you thought I was mad too. :)
I was editing the database to correct an error and executed a query that updated all the comments, since the beginning of the blog, to the phrase, "Only a WFRP 2e refugee is mad enough."
Nothing like seeing Query returned successfully: 98 rows affected, 67 ms execution time. appear in your window to wake you up.
I think I have a backup, but not a recent one. Indeed. "Only a WFRP 2e refugee is mad enough" to edit the production database!
Update
I have been able to recover all but the most recent comments. Crafting the UPDATE command now.
Update #2
I have restored all comments (going back 5 years!). To Jen and Teri, visitors from the A to Z challenge, apologies! I guess "history will show" that you thought I was mad too. :)
Posted by at 11:32 AM in kaffehaus
[Trackback URL for this entry]
And there was much rejoicing!
/M