We have a private wiki, which will eventually become public. We would
like to integrate the pages from our current public wiki into the
private wiki. The wikis are in different databases. Also, the public
wiki table names have a different prefix than the private wiki pages.
Here's the strategy I've come up with for doing this, and I'd appreciate
if anyone could point out potential problems, or an easier way of doing
things.
Fortunately, the amount of editing that will be done on the public wiki
after a copy is integrated into the private wiki will likely be small;
so we can handle such cases manually when we're ready to take the
private wiki public.
For simplicity, I'll call the private wiki I (for internal) and the
public wiki P.
Here's the strategy:
1) Dump P.
2) Do a simple text substitution on the dumped text file to change the
table name prefix appropriately.
3) From that dump file, create a copy of P (with prefix names changed),
I'll call it P2.
4) Check P2 to make sure everything is OK so far.
5) We have already copied a few pages from P to I, and modified them;
so, write a SQL script to remove pages that already exist in I from P2.
I'll have to figure out which tables are affected by this.
6) Write a SQL script to transfer all pages from I to P2 (this makes
sure we don't screw up the current I).
Here's a more problematic part;
7) Write a script (in python, for me) that will go through the images
directory in I, and copy the images to the same locations relative to
the P2 images directory. I'm guessing this will work, but don't know
enough about image storage and indexing to be sure. Alternatively, I
could simply not transfer image information over from I, and then use
importImages.php to import all of those images; but again, I'm not sure
if there might not be some table dependencies that would make this
difficult. Comments here are very welcome!
8) P2 now becomes I.
And that's it.
Many thanks in advance for any comments you can give (and I also hope
that some of the ideas in this might help others).
Ken