respect db_host when calling mysqldump

1 files changed, 12 insertions, 2 deletions

diff --git a/wordpress/wordpress-rsync-push-site b/wordpress/wordpress-rsync-push-site
index 09dc70c..225a6c4 100755
--- a/wordpress/wordpress-rsync-push-site
+++ b/wordpress/wordpress-rsync-push-site
@@ -44,6 +44,16 @@ do_rsync()
         rsync ${NO_ACT:+ -nv} -u -aRi --delete --partial "$conf_file" "$html_dir" "$remote_host":/"$target_dir"
 ) }
 
+remote_mysqldump()
+{
+        if [ "$DO_NOT_USE_SSH" ]
+        then
+                mysqldump --host="$db_host" "$db_name"
+        else
+                ssh -- "$db_host" mysqldump "$db_name"
+        fi
+}
+
 do_mysqldump()
 { (
         case "$NO_ACT" in
@@ -58,12 +68,12 @@ do_mysqldump()
         then
                 set -x
                 dumpfile=$(mktemp -p "$XDG_RUNTIME_DIR") || dumpfile=$(mktemp)
-                ssh "$db_host" -- mysqldump "$db_name" | gzip -c > "$dumpfile"
+                remote_mysqldump | gzip -c > "$dumpfile"
                 rsync --ignore-existing "$dumpfile" "$remote_host":"$of"
                 rm "$dumpfile"
         else
                 set -x
-                mysqldump "$db_name" | gzip -c | ssh "$remote_host" dd conv=notrunc "of=$of"
+                remote_mysqldump | gzip -c | ssh "$remote_host" dd conv=notrunc "of=$of"
         fi
 ) }