From 911dbc4426a7a42dbc6fc48ab61958fa6c6e1234 Mon Sep 17 00:00:00 2001 From: mh Date: Thu, 19 Nov 2009 02:34:21 +0100 Subject: be nicer during mysql backup sometimes it can happen that by locking all tables we run into error 24, which means to many open files. According to http://rackerhacker.com/2007/08/19/mysql-errcode-24-when-using-lock-tables/ we can use single-transaction to be nicer during backups. --- files/backup/mysql_backup.cron | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'files') diff --git a/files/backup/mysql_backup.cron b/files/backup/mysql_backup.cron index 705a854..1cb21ff 100644 --- a/files/backup/mysql_backup.cron +++ b/files/backup/mysql_backup.cron @@ -1 +1 @@ -00 01 * * * root /usr/bin/mysqldump --default-character-set=utf8 --all-databases --all --flush-logs --lock-all-tables | gzip > /var/lib/mysql/data/mysqldump.sql.gz && chmod 600 /var/lib/mysql/data/mysqldump.sql.gz +00 01 * * * root /usr/bin/mysqldump --default-character-set=utf8 --all-databases --all --flush-logs --lock-tables --single-transaction | gzip > /var/lib/mysql/data/mysqldump.sql.gz && chmod 600 /var/lib/mysql/data/mysqldump.sql.gz -- cgit v1.2.3