Tool for shifting tables from Mysql to Postgresql

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: mysql(at)lists(dot)mysql(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Tool for shifting tables from Mysql to Postgresql
Date: 2011-03-01 10:27:27
Message-ID: 4D6CCA0F.5050004@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-03-01 10:51:07 Re: restore a server backup
Previous Message Szymon Guz 2011-03-01 09:35:40 Re: pg_catalog.pg_stat_activity and current_query