[rt-users] Binary Attachments Corrupted in Migration to new box

[Mike Patterson]

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
>>