[rt-users] Upgrade RT

[Asif Iqbal]

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 ?


>
>
> 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 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/20090414/f03836a6/attachment.htm>