Thread:Project:Support desk/MySQL upgrade/reply

Hi Andreas!

To 1): Newer versions like 1.20 should be fine, maybe 1.17 received an according patch after [2] was asked, but I don't know for older ones (1.15 is from 2009...). Download a copy of the MediaWiki versions, which you are using, and check the file maintenance/tables.sql. This file contains the MySQL table definitions. When there is no TYPE option in it, you should be fine.

To 2): Best practices are the ones, which the MySQL guys give you; e.g. to always create a backup before starting and to run the upgrade scripts, which MySQL provides. But as far as the MediaWiki side is concerned: Not that I know of. I have updated a MySQL 5.0 to 5.1 some time ago and inside MediaWiki I had to change nothing at all.

To 3): Correct; especially this script upgrade1.5_php, which is mentioned as problemtic in [2] is not needed in your case. It would only be used when you updated MediaWiki to version 1.5, which in your case will not happen.