Matthew Richards wrote:

Hi All,

My Ubuntu server running mediawiki 1.10 died and I am moving to mediawiki 1.15 on CentOS. Both installations use mysql.

I have temporarily resurrected my 1.10 install so that I can recover the wiki content from the mysql database.

Can I simply export the mysql database from my 1.10 install and merge it with my fresh 1.15 install (assuming no table prefixes), or do I need to keep both versions the same to migrate the mysql data and then upgrade the new install afterwards?

Unpack the files from 1.15 on the new machine but do not install it, i.e. do not create an empty wiki. Copy the database across, along with LocalSettings.php and the images directory. Then run either maintenance/update.php or config/index.php from 1.15 to upgrade the copied database, as per the usual upgrade instructions. There is no need to install 1.10 on the new machine.

Note that if you installed 1.10 with the "backwards compatible" schema, you will need to specify the --default-character-set=binary option to mysqldump in order to copy it correctly.

-- Tim Starling