From 9a3d006a1f21b934b9735a031c55ed46956877f9 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 11 Jan 2022 22:46:06 +0100
Subject: replicate-db: use rsync

---
 replicate-db | 21 +++++++++++++++++----
 1 file changed, 17 insertions(+), 4 deletions(-)

diff --git a/replicate-db b/replicate-db
index 431b70f..8244ff7 100755
--- a/replicate-db
+++ b/replicate-db
@@ -38,10 +38,23 @@ printf '\n\n\n%s\n%s\n\n\n\n\n' "${root_pw}" "${root_pw}" | \
 tmp_file=$(mktemp)
 trap 'rm "${tmp_file}"' EXIT
 
-ssh master@10.100.10.1 '
-  cd /data/backup/mysql;
-  ls -t | grep -m1 '"'"'^database-.*\.xz$'"'"' | xargs pv
-' > "${tmp_file}"
+database_dump=$(
+  ssh master@10.100.10.1 '
+    cd /data/backup/mysql;
+    ls -t
+  ' \
+  | grep -xm1 'database-.*\.xz'
+)
+
+find /tmp \
+  -maxdepth 1 \
+  -type f \
+  -name "${database_dump}" \
+  -exec rsync -avP {} "${tmp_file}" \;
+
+rsync -avP \
+  "master@10.100.10.1:/data/backup/mysql/${database_dump}" \
+  "${tmp_file}"
 
 {
   printf 'SHOW SLAVE STATUS;\n'
-- 
cgit v1.2.3