#!/bin/bash
# loop isi file well_list.txt
# kemudian dump | gzip ke server lain
# contoh nama table xx_telo_xx
while read p; do
mysqldump -uuser -ppassowrd –skip-add-drop-table –skip-add-locks –lock-tables=false namadatabase $(mysql -uuser -ppassowrd -D namadatabase -Bse “SHOW TABLES LIKE ‘%$p\_%'”) | gzip -c | ssh user@servertujuan “cat > /home/user/backupdb-rowdata/only-rowdata_$p.sql.gz”
done < well_list.txt