Re: Moving from PostgreSQL to MySQL

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