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?
John Blumel
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)
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
John Blumel schrieb:
On Jun 5, 2005, at 7:36 pm, Brion Vibber wrote:
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.
OK, maybe this is related:
I'm using MediaWiki 1.4 on our intranet server; mysql 4.1.something is running.
The site was working perfectly well, until today I tried to remote-create an 1.5 test database. That failed when creating the user rights stuff. And, worse, the 1.4 wiki now shows only a blank page.
I tried to create a new site/database with the 1.4 wiki, but it fails when setting user privileges. Deleting the wikiuser or changing the privileges didn't help.
Any idea what's causing this?
Magnus
P.S.: I've set up a temporary wiki on another machine, but people keep calling and biting me into sensitive body parts, so please hurry ;-)
Magnus Manske wrote:
I'm using MediaWiki 1.4 on our intranet server; mysql 4.1.something is running.
The site was working perfectly well, until today I tried to remote-create an 1.5 test database. That failed when creating the user rights stuff. And, worse, the 1.4 wiki now shows only a blank page.
I tried to create a new site/database with the 1.4 wiki, but it fails when setting user privileges. Deleting the wikiuser or changing the privileges didn't help.
There's a link in RELEASE-NOTES about the authentication changes in MySQL 4.1 to a page on MySQL's site with some hints.
-- brion vibber (brion @ pobox.com)
mediawiki-l@lists.wikimedia.org