On Tue, Nov 18, 2008 at 10:37 PM, Tim Cutts <t...@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?
_______________________________________________ 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