[Mediawiki-l] Migration from MW 1.5 (MySQL 3.23) to 1.17 (MySQL 5.1) ?

[Boris Steipe]

Dear all,

I am trying to migrate an old but important Wiki from its current server to a new machine.

The old machine is a RH Linux running MW 1.5.3 with MySQL 3.23.
The new machine is VMware Linux running with MySQL 5.1.

My mysql usernames are not identical on the two machines.

I would prefer not to modify/upgrade the installation on the old machine. I can mysqldump the old database from the new machine with (--host=<old machine>) and read it into the new database. But I can get neither a copy of my old wiki nor a fresh install of 1.17 to work with these tables. E.g. when I run update.php I get a MySQL error:

 1005: Can't create table 'wikidb.transcache' (errno: 121) (localhost)

Can someone enlighten me as to the correct sequence of steps that would be expected to work for such a migration? Or am I even thinking in the right direction?

Thanks!
Boris