Hi,
I have made a patch to fix #550037, which I attached to this message.
The new version of the package is here:
http://ftparchive.gplhost.com/debian/pool/lenny/main/a/automysqlbackup/
Can you guys try it in Squeeze and let me know in the bts entry if this
fixed the issue?
Thanks in advance,
Thomas
diff -u automysqlbackup-2.5/automysqlbackup automysqlbackup-2.5/automysqlbackup
--- automysqlbackup-2.5/automysqlbackup
+++ automysqlbackup-2.5/automysqlbackup
@@ -351,7 +351,7 @@
LOGFILE=$BACKUPDIR/$DBHOST-`date +%N`.log # Logfile Name
LOGERR=$BACKUPDIR/ERRORS_$DBHOST-`date +%N`.log # Logfile Name
BACKUPFILES=""
-OPT="--quote-names --opt" # OPT string for use with
mysqldump ( see man mysqldump )
+OPT="--quote-names" # OPT string for use with mysqldump (
see man mysqldump )
# Add --compress mysqldump option to $OPT
if [ "$COMMCOMP" = "yes" ];
@@ -412,10 +412,16 @@
dbdump () {
touch $2
chmod 600 $2
+ if [ $1 = "information_schema" ] ; then
+ NEWOPT="--skip-opt ${OPT}"
+ else
+ NEWOPT="--opt $OPT"
+ fi
+
if [ -z "${USERNAME}" -o -z "${PASSWORD}" ] ; then
- mysqldump --defaults-file=/etc/mysql/debian.cnf $OPT $1 > $2
+ mysqldump --defaults-file=/etc/mysql/debian.cnf $NEWOPT $1 > $2
else
- mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
$OPT $1 > $2
+ mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
$NEWOPT $1 > $2
fi
return 0
}
diff -u automysqlbackup-2.5/debian/changelog
automysqlbackup-2.5/debian/changelog
--- automysqlbackup-2.5/debian/changelog
+++ automysqlbackup-2.5/debian/changelog
@@ -1,3 +1,10 @@
+automysqlbackup (2.5-6) unstable; urgency=low
+
+ * Fixes the --opt issue with the information_schema that needs --skip-opt
+ instead of --opt (Closes: #550037).
+
+ -- Thomas Goirand <tho...@goirand.fr> Tue, 22 Dec 2009 16:35:45 +0800
+
automysqlbackup (2.5-5) unstable; urgency=low
* Added Recommends: mutt (Closes: #532402).
