[rt-users] Upgrade RT

[Tim Cutts]

On 14 Apr 2009, at 3:09 pm, Asif Iqbal wrote:

> On Tue, Nov 18, 2008 at 10:37 PM, Tim Cutts <tjrc at sanger.ac.uk> wrote:
>
>>
>> On 18 Nov 2008, at 3:27 pm, Asif Iqbal 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
>>>
>>
>> I haven't tested the attachments thoroughly yet, so I don't know  
>> whether it
>> worked.  I just used one of our regular backup dumps, which isn't  
>> massively
>> complicated.  Our RT instance is replicated, and we back up off the  
>> slave
>> using:
>>
>> mysqldump --defaults-extra-file=/mysql/data_3307/slave.cnf
>> --single-transaction --flush-logs --master-data=2 --all-databases - 
>> q | gzip
>>> backup.gz
>
>
> How do I do the mysqldump w/o locking ?

You can't.  Not if you want a guaranteed consistent backup, anyway.

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.