News for hackers. Stuff that matters.

A comment on Ask HN: What's the worst you've ever screwed up at work?. Parent comment

Re:Ask HN: What's the worst you've ever screwed up at work? by gargarplex on Wednesday January 29, 2014 @12:51PM (#7145472)
I always add a LIMIT even when not necessary.

Why doesn't MySQL have a version control baked in? Even if it preserves just the last n hours of state..

[ Parent | on HN ]
Re:Ask HN: What's the worst you've ever screwed up at work? by DCoder on Wednesday January 29, 2014 @02:45PM (#7146233)
Since you're using MySQL, you can start it with --i-am-a-dummy [1]. Not a backup, but still handy.

[1] http://dev.mysql.com/doc/refman/5.6/en/mysql-tips.html#safe-...

[ Parent | on HN ]
Re:Ask HN: What's the worst you've ever screwed up at work? by michaelmior on Wednesday January 29, 2014 @01:51PM (#7145891)
That's what backups are for. With appropriate checkpoints, you can roll back to any point in time with a reasonable level of precision.
[ Parent | on HN ]
Re:Ask HN: What's the worst you've ever screwed up at work? by icedchai on Wednesday January 29, 2014 @02:43PM (#7146225)
It kind of does. It's called the binary log.
[ Parent | on HN ]
Re:Ask HN: What's the worst you've ever screwed up at work? by gargarplex on Wednesday January 29, 2014 @05:36PM (#7147607)
Didn't know about this! Thanks.

https://dev.mysql.com/doc/refman/5.0/en/binary-log.html

https://dev.mysql.com/doc/refman/5.0/en/point-in-time-recove...

[ Parent | on HN ]