Geeezz. I hate it when that happens… A critical mistake that ruins the project. I’m restructuring a contact database that has become large and complex. I want to separate the data into several tables. I will build a relational (one-to many) db using an SQL query to join them. The trick is to import the data to the new structure. It’s tedious. I drafted several queries to display the data (so far so good) and then wrote some coldfusion code that would allow one to edit | insert | delete. That’s where I screwed the pouch. My insert statement had a slight syntactical error (you should hardly notice) which, instead of updating the fields of a single record, overwrote the records of the ENTIRE database. Damn. There’s no un-do button for this one…

Keep incremental back-ups.