[xwiki-users] Re: Moving from PostgreSQL to MySQL

[Vincent Massol]

This is nice to know, thanks. That said, we need to find the  
configuration to make XWiki work directly with PostgreSQL...

Sergiu has created an issue to keep track of the progress at http:// 
jira.xwiki.org/jira/browse/XWIKI-803

Thanks
-Vincent

On Feb 2, 2007, at 2:10 PM, Dandre wrote:

> 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


	

	
		
___________________________________________________________________________ 
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com