[Automysqlbackup-users] Mysqlbackup fails an brings the server down

[Ward L. <wa...@lo...>]

Hello,

I currently use automysqlbackup to backup 10databases. There is one big
database that contains a table with +- 780.000records. When mysqlbackup
executes it fails (on that table) and brings my websites down (maybe the
load is so high that apache processes can't answer in time). Looks like
there are a lot of query's executed at the moment of backup and maybe the
query's are locking each other.

I also get the following by email:

mysqldump: Error 2013: Lost connection to MySQL server during query when
dumping table `video` at row: 745740

I think this are 2seperate problems:

   - Mysql backup script failing
   - Website's are down (because the use of too many resources?)


Do you guys have any ideas how to fix this? Can you let the script run in
low priority mode, so that it doesn't eat the resources and does not lock
any tables ?

Thanks!
Ward