[rt-users] binary attachments corrupt

Rémi mirebob at gmail.com
Thu Dec 11 11:46:58 EST 2008


>
>
> After the upgrade, I had the problems described in UPGRADING.mysql:
> - multiple login requests
> - corrupt binaries
>
>
hi andré

I had the same problem with corrupted attachments after a 3.8.1 upgrade,
I solved this problem yesterday by adding the paramater
"--default-character-set=binary" when I dump the old database and when I
import the dump into the new one.

here is the whole upgrade produre i've done :

oldserver# mysqldump --default-character-set=binary -u root -p $rtdb>
dump.sql

newserver# mysql --default-character-set=binary -u root -p $rtdb < dump.sql

newserver# rt-setup-database -dba root --prompt-for-dba-password --action
upgrade
(from 3.6.0 -> 3.8.0)

newserver# perl
/etc/request-tracker3.8/upgrade/schema.mysql-4.0-4.1.pl$rtdb $rtuser
$rtuser_passwd > sql.queries

newserver# mysql -u root -p $rtdb< sql.queries

newserver# rt-setup-database -dba root --prompt-for-dba-password --action
upgrade
(from 3.8.0 -> 3.8.1)

Rémi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081211/fdd25590/attachment.htm>


More information about the rt-users mailing list