From bcc8c599369d014b5c8779334839ea62901a80a4 Mon Sep 17 00:00:00 2001
From: Dan Goodliffe <dan@randomdan.homeip.net>
Date: Tue, 9 Apr 2019 18:48:18 +0100
Subject: Revised mysql backup dump

---
 scripts/backup.cron | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'scripts/backup.cron')

diff --git a/scripts/backup.cron b/scripts/backup.cron
index df389c6..e6399a3 100755
--- a/scripts/backup.cron
+++ b/scripts/backup.cron
@@ -44,7 +44,7 @@ touch ${basedir}/${prefix}.0
 
 echo "Begin MySQL @ `date`" >> ${basedir}/time
 rm -f ${basedir}/${prefix}.0/mysql.sql.xz
-mysqldump --defaults-extra-file=/root/.my.cnf --extended-insert=off -xA | xz > ${basedir}/${prefix}.0/mysql.sql.xz
+mysqldump --all-databases --triggers --routines --events | xz > ${basedir}/${prefix}.0/mysql.sql.xz
 
 echo "Begin LDAP @ `date`" >> ${basedir}/time
 rm -f ${basedir}/${prefix}.0/ldap.ldif.xz
-- 
cgit v1.2.3