Re: Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Dhaval Jaiswal
By default Postgresql database encoding in UTF8. It seems to me by seeing error that database encoding in mysql is different from it. -- Cheers, Dhaval Jaiswal On 01/03/2011 3:57 PM, Adarsh Sharma wrote: Dear all, I want to convert some tables from Mysql database to Postgresql Database

Re: Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Jaime Crespo Rincón
2011/3/1 Adarsh Sharma : > Dear all, > > I want to convert some tables from Mysql database to Postgresql Database in > Linux Systems ( Ubuntu-10.4, CentOS ). [...] > invalid byte sequence for encoding "UTF8": 0xe3ba27 > HINT:  This error can also happen if the byte sequence does not match the > enc

Tool for shifting tables from Mysql to Postgresql

2011-03-01 Thread Adarsh Sharma
Dear all, I want to convert some tables from Mysql database to Postgresql Database in Linux Systems ( Ubuntu-10.4, CentOS ). Can someone Please tell me tool for it that makes it easier. I am able to done it through FW tools in Windows System but i want to achieve it in Linux ( CentOS ) Syste

Re: Mysql to Postgresql

2011-02-22 Thread Jaime Crespo Rincón
2011/2/22 Adarsh Sharma : > Dear all, > > Today I need to back up a mysql database and restore in Postgresql database > but I don't know how to achieve this accurately. Have a look at: "mysqldump --compatible=postgresql" command:

Mysql to Postgresql

2011-02-22 Thread Adarsh Sharma
Dear all, Today I need to back up a mysql database and restore in Postgresql database but I don't know how to achieve this accurately. Can anyone kindly describe me the way to do this. Thanks & best Regards, Adarsh Sharma -- MySQL General Mailing List For list archives: http://lists.mysql.