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