Hi Adarsh, There are very good tools out for migration from Mysql to PostgreSQL. EnterpriseDB has the migration studio which will help to migrate Mysql to PostgreSQL.
http://www.enterprisedb.com/solutions/mysql-vs-postgresql/how-to-move-from-mysql-to-postgresql Best Regards, Raghavendra EnterpriseDB Corporation On Tue, Mar 1, 2011 at 3:57 PM, Adarsh Sharma <adarsh.sha...@orkash.com>wrote: > 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 ) System. > > I researched a lot & tried below steps : > > 1. mysqldump --compatible=postgresql wiki20100130 > > /hdd4-1/wiki20100130_mysql108feb22.sql > > 2. sed "s/\\\'/\'\'/g" wiki20100130_mysql108feb22.sql > > 3. bin/psql -Upostgres wiki20100130 < > /hdd4-1/wiki20100130_mysql108feb22.sql > > invalid byte sequence for encoding "UTF8": 0xe3ba27 > HINT: This error can also happen if the byte sequence does not match the > encoding expected by the server, which is controlled by "client_encoding". > ERROR: invalid byte sequence for encoding "UTF8": 0xee6c65 > HINT: This error can also happen if the byte sequence does not match the > encoding expected by the server, which is controlled by "client_encoding". > ERROR: invalid byte sequence > > > I think a tool would ease that work. > > Thanks & best Regards, > > Adarsh Sharma > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
