Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
Recent backups are so important. We all feel the pain at one point. Lesson learned.
-
je11zi4978yYou performed manual queries that had potential to delete real values in a production environment... and didn't take any precautions like backing up right before using a DELETE statement? Or perhaps staging to development environment instead of production?
You deserve this lesson. -
@je11zi I work in a start-up... There is no test environment, only 1 production server. And these small mistakes are part of learning....
-
Mistakes happen. Check out Percona XtraBackup tool. You can setup daily incremental/full backups
-
willol13898y@playmast3r your company is a start-up and the processes are already fucked up? That's sad.
Being a start-up is no excuse, you have to do things right from the beginning or things will never be right -
@willol it's a startup in truest sense... They have fired all employees... I am the only employee under 3 co-founders... So there is lot of stress and dismay....
Related Rants
MySQL should have a recycle bin. I just deleted whole "user" table by mistake... Forgot to add where clause properly... Had to restore 2 days old backup copy. I just hope no accounts were created or someone changed their password in last 2 days....
undefined
mysql
delete
table
user
backup