I apologize for coming to this list for help out of the blue, but I've run out of other resources to check.

I'm trying to move the contents of an existing MW installation, v.1.10.0, to a new version of MW on a different server. I don't get a choice about what version is put on the new server (ISP canned install), so it's 1.15.4. It's already installed there, tables/wiki user created in MySQL, etc. The wiki DB user has a different name on the two systems, and on the new system the tables have a mw_ prefix. Again, I didn't get a choice in this matter.

Now, my SQL is very good - it's what I do all day - and I'm perfectly willing to try to export the contents of the old wiki as SQL/DDL, search/replace/alter those as needed, and import them into the new database. But I gather this is a bad, messy idea. Even if the columns in the 34 tables from 1.10 haven't changed, there's the question of the seven tables which have been added to the schema since then. Nor can I find any good version-by-version docs on how the schema has changed over time.

There's also the possibility of exporting and importing by some means other than altering the database directly - e.g. Special:Export - but that seems to not be a viable "export entire wiki in bulk" option.

I don't absolutely need to export revision history and I don't care if details of page ownership etc are lost. If I can just grab latest version of each page, even if they are all marked as owned by WikiSysop, that's fine. I can remake template inclusions and other niceties by hand - there aren't many. It's just the 500+ pages of actual body content that are the problem.

Can anybody give advice on this?

Todd Belton

Harvard Graduate School of Design