Deleted all comments by accident
I just accidentally deleted all comments made on this blog.
This blog is homegrown and hand-made. It has a very simple spamfilter that catches most spam comments. The few that make it through though, I've been deleting myself using the mysql console.
I tend to write simple queries, ending in: .. AND id = 1234, but today I forgot the id =. I had a backup from October 2008, so some old comments are back now, but I'm still pretty sad.
Lesson from today: make backups! I'm pretty good with things I do for clients, but I tend to not uphold the same standards for my own projects.
Quick MySQL tip: add comments
MySQL allows comments to be added with the standard /* */ syntax. If your application is getting more complex, it can become more difficult to figure out where certain queries originate from.
By simply adding a comment in front of your query, it will be very easy to spot the origin of some of your queries.
/* recent blogposts */ SELECT id, title, time FROM blogposts ORDER BY time DESC limit 10
The comment will show up as the first thing in SHOW [FULL] PROCESSLIST, MySQL administrator and your log/slow-log files.
