On Thu, Apr 16, 2009 at 7:36 PM, Tim Cutts <t...@sanger.ac.uk> wrote:

>
> On 14 Apr 2009, at 3:09 pm, Asif Iqbal wrote:
>
>  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 ?
>>
>
> You can't.  Not if you want a guaranteed consistent backup, anyway.
>

Actually the --master-data and --single-transaction make sure the tables are
not locked

"The 
--master-data<http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html#option_mysqldump_master-data>option
automatically turns off
--lock-tables<http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html#option_mysqldump_lock-tables>.
It also turns on
--lock-all-tables<http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html#option_mysqldump_lock-all-tables>,
unless 
--single-transaction<http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html#option_mysqldump_single-transaction>also
is specified
"

Plus it took me less than 14 mins to dump about 8G data


>
>
> 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

Reply via email to