[rt-users] Upgrade RT

Tim Cutts tjrc at sanger.ac.uk
Tue Nov 18 11:37:34 EST 2008


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

Are there particular attachment types I should look for to check  
whether things are working?

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. 



More information about the rt-users mailing list