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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
