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