On Wed, Nov 19, 2008 at 10:08 AM, Tim Cutts <t...@sanger.ac.uk> wrote:
> > 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? >> > > OK, I'm now getting a bit concerned, because I've re-done my upgrade > procedure based on dumping with --default-charset=binary, but I've still got > a problem with corrupted attachments. I imagine there's a huge amount of > past material on this list about this problem - are there any good summary > documents somewhere? The procedure I'm trying to follow is: > > 1) mysqldump my RT 3.4.2 instance, which is running on a MySQL 4.1.11 > database (maybe this is my problem? Maybe I don't need the 4.0->4.1 update > at all?) > > 2) Load that dump into a new MySQL 5.0 database on my new system > > 3) Apply the 3.4.2 -> 3.8.0 update > > 4) Apply the MySQL 4.0->4.1 patch, if necessary (I'm now wondering whether > it is, or whether applying it is actually causing the problem) > It completes after 918 mins with this error message # time mysql -u root -p rt3 < sql.queries Enter password: ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2 real 918m45.115s user 0m0.088s sys 0m0.072s > > 5) Apply the 3.8.0 -> 3.8.1 update > > Any ideas? > > > Tim > > > -- > The Wellcome Trust Sanger Institute is operated by Genome ResearchLimited, > a charity registered in England with number 1021457 and acompany registered > in England with number 2742969, whose registeredoffice is 215 Euston Road, > London, NW1 2BE. > -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com