[Phpwiki-talk] Restoring a ZipDump backup

[Frank S. <fra...@rn...>]

Hi all,

I currently use gdbm as my phpwiki backend, but for various reasons I want
to change that to a mySQL backend. So what I thought of doing was taking a
ZipDump of the entire wiki, changing the backend (setting up the database
schema, changing the entry script, blah blah) and use the loadfile action on
the new (empty) wiki to restore the wiki to its original state.

Currently this just doesn't work. Well, not as I expected, at any rate. The
first revision is saved as version one, and subsequent revisions have to be
merged by hand.

What I want is for the wiki to be restored in such a way that the users (who
are intimately familiar with details like what the current revision of
ArbitraryPage is, and what its major and minor edits are, etc) never even
notice the difference.

I can't see anywhere in phpwiki to do this. Is there? Failing that, if I
wanted to hack this up, where would I start?

My first thought was that, since I'm moving the pages to mySQL, I should
just write something that processes each (RFC822 encoded) page and applies
the appropriate SQL to the database. But this doesn't solve the general
problem of how to move one's backend to something arbitrary - what if one
wanted to move from a mySQL backend to a CVS backend, for instance? Or
flatfile to PostgreSQL?

frank