SQL nightmare & a Blogging Book
If you were visiting the blog just a few moments ago, you might have noticed that the blog was absolutely devoid of comments! I managed to accidentally empty the comments from the database whilst making some SQL changes.
Thankfully, I have always made a backup of SQL database before doing any work. I learned to do this some years ago, after accidentally nuking a whole site (with no chance of getting it back).
So all I had to do was get the comments table from my backup and restore it. Sweet!
And what I was trying to do was update some URLs which have died - to redirect somewhere else. Always good to keep on top of the "money links"
Make Money from Blogging
Thomas Sinfield has written a book called "make money from blogging". I've not read it yet, so can't tell you if it's any good or not. I also don't know how much Thomas earns from blogging, so it might not fit your needs.

Comment by Forrest — November 28, 2007 @ 10:43 pm
I've made some dumb mistakes in the past, like running an update or delete query and forgetting to write or include the where clause. Transactions can be a beautiful thing…!