[rt-users] Upgrade RT

[Asif Iqbal]

On Wed, Nov 19, 2008 at 10:08 AM, Tim Cutts <tjrc at 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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090426/0f2b03ca/attachment.htm>