Todd,
That fixed it.
Thanks,
Mike
Todd Chapman wrote:
Ithin you have to mysqldump with: --default-character-set=binary
-Todd
On Wed, May 10, 2006 at 08:36:41AM -0700, Mike Patterson wrote:
My binary attachments (spreadsheets, screenshots, etc..) got corrupted
after migrating to a new box.
I'm migrating from:
FreeBSD 4.11, RT 3.2.2, MySQL 4.1.7, Apache 1.3.33, Perl 5.8.4,
mod_perl-1.29, DBI-1.42_1
--TO-->
RHEL 4.3, RT 3.4.5, MySQL 4.1.2-3, Apache 2.0.52, Perl 5.8.5,
mod_fastcgi-2.4.2, DBI-1.40-8
Everything else seems fine, but the attachments are corrupt.
How I upgraded:
1) Install RT 3.4.5 on my RHEL box.
2) Dumped mysql database:
mysqldump --opt --add-drop-table --single-transaction --user=root
--password=my_pass_was_here rt3 | gzip > /usr/backup/rt3_db_last2.sql.gz
_______________________________________________
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
