On 14 Apr 2009, at 3:09 pm, Asif Iqbal wrote: > On Tue, Nov 18, 2008 at 10:37 PM, Tim Cutts <[email protected]> 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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
