I always add a LIMIT even when not necessary. Why doesn't MySQL have a version c... | Hacker News

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

		gargarplex on Jan 29, 2014 \| parent \| context \| favorite \| on: Ask HN: What's the worst you've ever screwed up at... 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..

DCoder on Jan 29, 2014 | [–]

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-...

icedchai on Jan 29, 2014 | | [–]

It kind of does. It's called the binary log.

gargarplex on Jan 29, 2014 | | [–]

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...

michaelmior on Jan 29, 2014 | [–]

That's what backups are for. With appropriate checkpoints, you can roll back to any point in time with a reasonable level of precision.

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