23
peaam
8y

I managed to accidentally clear everybody's usernames and email addresses from an SQL table once. I only recovered it because a few seconds before, I'd opened a tab with all the user data displayed as an HTML table. I quickly copied it into Excel, then a text editor (saving multiple times!), then managed to write a set of queries to paste it all back in place. If I'd refreshed the tab it would have all gone!

Comments
  • 3
    We're there passwords involved?
  • 3
    No thankfully. So the usernames/emails were part of a WHERE query and I'd misspelt the variable names, because those variables were missing it replaced them with nothing! And no, the passwords weren't in the HTML table :-)!
Add Comment