The wiki doesn't quite cover all the issues, in particular, I haven't figured out how to get attachments across properly. Is there a tool or procedure out there that is known to work?
# --extended-insert=false because postgres doesn't do extended inserts
# --compatible=mysql323 comes closest to working thus far. --compatible=postgresql is a joke
# --default-character-set of UTF8 seems to help
# am trying
mysqldump -p --complete-insert rt3 --extended-insert=false --compatible=mysql323 --default-character-set=UTF8 --user=root > dump1.sql
# edit the dump file to comment out the lock tables and unlock tables statements, and convert the "drop table if exists" into "delete from"
# run mysql2pgsql.perl on the file (my2pg.pl segvios)
psql -f dump.sql # blows up on about 5% of attachment insert lines like
# psql:m2.sql:661: ERROR: syntax error at or near "2006" at character 44117
# psql:m2.sql:661: LINE 1: .../Producer(GPL Ghostscript 8.15)\n/CreationDate(D:'2006-05-23...
--
Mike Taht
PostCards From the Bleeding Edge
http://the-edge.blogspot.com
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
