Re: backup locking tables on 5.0.24

2006-08-23 Thread Chris
matt_lists wrote: chris smith wrote: On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote: We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the tables for selects the backup takes 3 hours, so the site is down the whole time I'm using this backup line mysqldump -d -f --quote-names

Re: backup locking tables on 5.0.24

2006-08-23 Thread matt_lists
chris smith wrote: On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote: We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the tables for selects the backup takes 3 hours, so the site is down the whole time I'm using this backup line mysqldump -d -f --quote-names --skip-add-locks da

Re: backup locking tables on 5.0.24

2006-08-23 Thread chris smith
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote: We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the tables for selects the backup takes 3 hours, so the site is down the whole time I'm using this backup line mysqldump -d -f --quote-names --skip-add-locks database > outfile mys