Thread:Project:Support desk/MySQL upgrade

Hi MediaWiki users,

we have several MediaWiki instances, versions 1.15, 1.16, 1.17, and 1.20, running on our server. Currently, the databases are hosted at a dedicated database server using MySQL 5.0.96. We are planning to upgrade this database server to MySQL 5.5. I searched this support desk for similar posts, and found, e.g., [1,2]. In particular, [2] suggests that there will be problems due to a bug in "update.php" script in MW 17, which uses MySQL TYPE.

I have a couple of questions, maybe someone has some insights: 1.) Can anybody confirm this bug in [2]? Is this bug also in 1.15, 1.16, or 1.20? 2.) Are there any best practices and/or tips for our planned MySQL upgrade? 3.) I assume I do not (!) have to run need to run any MW maintance scripts - right?

Any pointers would be very much appreciated ;)

Kind regards Andreas

[1] http://www.mediawiki.org/wiki/Thread:Project:Forum/Mediawiki_MySQL_upgrade#x.28RESOLVED.29_Mediawiki_MySQL_upgrade_1321 [2] http://www.mediawiki.org/wiki/Thread:Project:Support_desk/MySQL_5.5_and_MW_17_-_ENGINE_vs_TYPE#MySQL_5.5_and_MW_17_-_ENGINE_vs_TYPE_6397