4 ms·
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..
by gargarplex 13y ago
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..
- michaelmior 13y agoThat's what backups are for. With appropriate checkpoints, you can roll back to any point in time with a reasonable level of precision.
- icedchai 13y agoIt kind of does. It's called the binary log.
- gargarplex 13y agoDidn'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/binary-log.html https://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html https://dev.mysql.com/doc/refman/5.0/en/point-in-time-recove...
- DCoder 13y agoSince 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-updates http://dev.mysql.com/doc/refman/5.6/en/mysql-tips.html#safe-...