<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Just installed the latest Debian MySQL updates and was shown the following public service announcement. I'm glad Ruby on Rails makes it so easy to switch databases; looks like it may be about time for Postgres.</div><div><br></div><div>"mysql-5.1 (5.1.61-1) stable-security; urgency=high<br><br> Due to the non-disclosure of security patch information from Oracle,<br> we are forced to ship this upstream version update of MySQL 5.1 into<br> all releases that carry MySQL 5.1. There are several known incompatible<br> changes, which are listed below, taken from dev.mysql.com's changelogs,<br> available here: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-x.html<br><br> 5.1.51:<br> Incompatible Change: Previously, if you flushed the logs
using FLUSH<br> LOGS or mysqladmin flush-logs and mysqld was writing the error log to<br> a file (for example, if it was started with the --log-error option),<br> it renamed the current log file with the suffix -old, then created a<br> new empty log file. This had the problem that a second log-flushing<br> operation thus caused the original error log file to be lost unless<br> you saved it under a different name. For example, you could use the<br> following commands to save the file:<br> .<br> shell> mysqladmin flush-logs<br> shell> mv host_name.err-old backup-directory<br> .<br> To avoid the preceding file-loss problem, renaming no longer<br> occurs. The server merely closes and reopens the log file. To
rename<br> the file, you can do so manually before flushing. Then flushing the<br> logs reopens a new file with the original file name. For example, you<br> can rename the file and create a new one using the following commands:<br> .<br> shell> mv host_name.err host_name.err-old<br> shell> mysqladmin flush-logs<br> shell> mv host_name.err-old backup-directory<br> .<br> (Bug #29751)<br> .<br> References: See also Bug #56821.<br><br> 5.1.55:<br> Incompatible Change: When auto_increment_increment is greater than<br> one, values generated by a bulk insert that reaches the maximum<br> column value could wrap around rather producing an overflow error.
..."<br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div></div></body></html>