mydumper/myload

loop.sh

#!/bin/bash
set -e -o pipefail

user=root
password=hackme
host=127.0.0.1
port=3306

dbs=$(mysql -u$user -p$password -h$host -P$port -e 'SHOW DATABASES;' | tail -n+2)

dbs=$(echo "$dbs" | grep -v '^\(information_schema\|performance_schema\|sys\|mysql\)$')
echo -e "Databases:\n\n$dbs\n\n"

echo "Started at `date +%Y-%m-%d\ %H:%M:%S`"

mkdir backup2

for db in $dbs; do
  (
    set -x;
    mydumper \
      --threads 16 \
      --host $host \
      --port $port \
      --user $user \
      --password $password \
      --database $db \
      --compress \
      --compress-protocol \
      --outputdir backup2/$db
      #--no-backup-locks \
      #--use-savepoints \
      #--queries-per-transaction=5000 \
      #--rows="10000000" \
      #--long-query-guard 999999 \
      #--less-locking \
      #--no-locks \
      #--lock-all-tables \
      #--trx-consistency-only \
      #--logfile backup2/backup-$db.log
      #--threads 4 \
  )
  #(
  #  set -x;
  #  myloader \
  #    --threads 16 \
  #    --host $host \
  #    --port $port \
  #    --user $user \
  #    --password $password \
  #    --database $db \
  #    --compress-protocol \
  #    --directory backup2/$db
  #    #--verbose 3 \
  #)
done

echo "Finished at `date +%Y-%m-%d\ %H:%M:%S`"