Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

My password update script for one site used this SQL:

UPDATE Users SET Password=?

We had backups. Selective restore. 7 accounts that were new, not in the backup, got a special flag that required a reset.



Very similar situation here although the query had a syntax error which meant it didn’t go through, but initially I didn’t realise that and had to post the dreadful question on Slack “do we have backups of the production DB?”.

Years later I still consider it my biggest screw up. Everything else can be explained by bad processes, documentation, etc but this one is just me being stupid.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: