[rt-users] Upgrade RT

[Tim Cutts]

On 18 Nov 2008, at 4:47 pm, Tim Cutts wrote:

>> What switches did you use to dump the mysql? I see few gotcha's about
>> using binary characters
>> and separate dump  for attachment table and stuff
>
> OK, yes, I've just looked at an attachment to one of our tickets, and
> yes, it's corrupted.  Bugger.  So I've obviously missed something.  I
> thought that all one needed to do was to apply the mysql 4.0->4.1
> patches at the appropriate point, but clearly something is wrong.  Or
> is it what you allude to above, and we need to do something smarter
> when dumping the Attachment table?  Can you give me some references to
> where you've seen the gotchas?

Answered my own question.  About to test again using --default- 
character-set=binary and see whether that fixes things.

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.