#!/bin/sh
#
# mkmysqldump -- dump MySQL (master) data
-# Copyright (c)2015 Alexander Barton <alex@barton.de>
+# Copyright (c)2015-2017 Alexander Barton <alex@barton.de>
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
echo
}
+# Make sure the environment is "sane", for example, mysql(1) depends on the
+# HOME environment variable to be set.
+[ -n "$HOME" ] || HOME=$( getent passwd "${LOGNAME:-root}" | cut -d: -f6 )
+export HOME
+
for cmd in mysql mysqldump; do
if ! which "$cmd" >/dev/null 2>&1; then
echo "$NAME: \"$cmd\" command not found!"
;;
"--user"|"-u")
[ $# -ge 2 ] || Usage
- MYHOST="$2"
+ MYUSER="$2"
shift 2
;;
"--password"|"-p")
umask 0077
-[ -n "$MYPW" ] && PWSWITCH="--password='$MYPW'" || PWSWITCH=""
+[ -n "$MYPW" ] && PWSWITCH="--password=$MYPW" || PWSWITCH=""
echo "Getting list of databases from server ..."
DATABASES=$(
echo "Checking slave status ..."
Slave_IO_Running=""; Slave_SQL_Running=""
-eval "$(echo 'SHOW SLAVE STATUS\G' | mysql | sed -n '/Running/p' | sed 's/: /=/g')"
+eval "$(echo 'SHOW SLAVE STATUS\G' | mysql -h "$MYHOST" -u "$MYUSER" $PWSWITCH | sed -n '/Running/p' | sed 's/: /=/g')"
if [ -n "$Slave_IO_Running" -o -n "$Slave_SQL_Running" ]; then
if [ "$Slave_IO_Running" = "Yes" -a "$Slave_SQL_Running" = "Yes" ]; then
echo "Server is running as MySQL slave, replication is Ok."
if [ -n "$COMPRESS" -a -s "$OUTFILE" -a $r -eq 0 ]; then
echo "Dump done: $(date)"
echo "Compressing dump file ($COMPRESS) ..."
- $COMPRESS "$OUTFILE"
+ $COMPRESS "$OUTFILE" 2>&1
+ [ $? -eq 0 ] || echo "Error compressing dump file!" >&2
fi
echo "End: $(date)"
echo
if [ $r -eq 0 ]; then
echo "Dump command exited with code 0, success."
+ echo
else
echo "Dump command FAILED with code $r!" >&2
ErrorNotice
fi
-echo
exit $r