Moving from PostgreSQL to MySQL

[Dandre]

Ok, the only problem I encountered while surfing the wiki is that it 
throws up exceptions while saving stuff. Maybe XWiki has a problem or 
maybe the problem I encountered while copying is the bugger.
Anyway, I think we can use this way to help shape XWiki to use an old 
xwiki db in postgres directly as MySQL.

What you do is you take your old xwiki postgres db, use the SQuirreL (or 
any DB copier) to copy over the tables from your postgres to MySQL. Move 
to the new xwiki while pointing at your MySQL db. Then move back to 
postgres and let the new XWiki point to Postgres again. MySQL and XWiki 
will "straighten" things out that will allow you to use the new Xwiki 
with Postgres. I hope this will work for everyone as it worked for me 
(well it almost worked 100%  :-)  ).

Regards,
Dandre