| 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: | Whole Thread | Raw Message | 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
| 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 |