Re: [rt-users] Migration from MySQL to PostreSQL - corrupt characters (german umlaut)

[Maik Nergert]

I found an older post on the PostgreSQL mailinglist with same problems http://www.postgresql.org/message-id/d960cb61b694cf459dcfb4b0128514c207bb6...@exadv11.host.magwien.gv.at

And I was able to fix the issue by dumping and re-importing the db!


# Create empty PG-DB


# Run importer
rt-importer PATH

rt-setup-database --action create,schema,acl --dba rt_user --dba-password DBPASS # Run Update-Pg-Sequences Script (http://requesttracker.wikia.com/wiki/MigrateMysql2PostgresqlV4#Import_your_RT_database)

# Dump DB as latin1
pg_dump -E LATIN1 rt4 > rt4latin.sql

# Replace client_encoding
sed -i 's/LATIN1/UTF8/' rt4latin.sql

# Recreate empty DB
rt-setup-database --action drop --dba rt_user --dba-password DBPASS


# Import DB
psql rt4 < rt4latin.sql

rt-setup-database --action create,schema,acl --dba rt_user --dba-password DBPASS

smime.p7s
Description: S/MIME Cryptographic Signature