DELETE FROM site_page_content WHERE site_id - 1450;
Whoops! Is that a minus sign or an equal sign near the end? Equal sign--just the one site gets deleted. Minus sign...every single website gets deleted (2,500 of them!) except, ironically, the one site that was supposed to be deleted.
Fortunately, because I
Apparently the bigger problem is that we are a little too quick on the draw when it comes to making changes on the production server. With only two programmers, though, it's hard to rationalize going to the time and effort of setting up a "system," although it would seem that we're rapidly getting to the point where NOT setting up a system is costing us more time and effort.