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