John Blumel wrote:
What's the current recommendation on which version of MySQL is preferred?
Is it still 4.0.x, where x is greater than 13?
Or were the issues related to 4.1 resolved?
At this time I would still recommend the current 4.0.x release if you have your choice of databases and don't desperately need 4.1 for some other reason.
If you must use 4.1, things to watch out for include:
* Make sure your PHP installation uses the updated client libraries, or else use the work around with old passwords mode (see RELEASE-NOTES)
* If MySQL's default charset is set to UTF-8 you may get errors about some indexes being too long. You can try making them shorter in tables.sql, or switch the default to latin1 to use 8-bit indexing.
* If the default charset is set to latin1, mysqldump may corrupt your data by "converting" it to UTF-8 unless you specify the --charset parameter.
There may be additional problems with use of compressed revisions which I have not tested, as the old_text field is specified as a TEXT, not a BLOB type.
-- brion vibber (brion @ pobox.com)