Re: [Phpwiki-talk] Re: WLUG Wiki <-> phpWiki

[Matt B. <ma...@ma...>]

On Wed, 2005-06-22 at 22:26 +1200, Matt Brown wrote:

> Is there a better way to do this? I might try a direct database dump /
> import, but I thought the database fields had changed which might cause
> problems?

Hate to reply to myself, but I found a way to successfully import the
data. 

pg_dump -a -dD -O wiki > wiki-mattb.sql

Where wiki was the name of the database all the current wiki data is in.
The -dD flags are important as it enables output of the column names.
This avoids triggering an error on the import into the page table as
there is a new column there. 

It's very very slow to import the 3000+ pages we have via this method,
but it worked :)

Now on to porting all our other changes up to HEAD.

Regards

-- 
Matt Brown
ma...@ma...
Mob +64 275 611 544 www.mattb.net.nz