Script for quickly moving docker volume to another server

move-volume.sh

# Script for quickly moving docker volume to another server

echo "List of all running docker containers"
docker ps --format "table {{.Names}}"
echo " ============================== "

docker ps --format='{{.Name }}'

# defaults
REMOTE_HOST='admin@193.124.205.64'
REMOTE_FOLDER='/home/admin/inbox/www'
CONTAINER='nginx'

read -p "Type the name of container which you want to backup, default is $CONTAINER : " input
CONTAINER=${input:-$CONTAINER}

read -p "Type the remote host details, default is $REMOTE_HOST: " input
REMOTE_HOST=${input:-$REMOTE_HOST}

read -p "Specify full path to existing remote folder, default is $REMOTE_FOLDER: " input
REMOTE_FOLDER=${input:-$REMOTE_FOLDER}


for row in $(docker inspect $CONTAINER | jq -cr '.[].Mounts[].Source'); do
	echo "Working with volume ${row}"
	cd ${row}
	tar -zcvf $CONTAINER.tar.gz *
	ssh $REMOTE_HOST "mkdir -p $REMOTE_FOLDER"
	scp $CONTAINER.tar.gz $REMOTE_HOST:$REMOTE_FOLDER/..
	ssh $REMOTE_HOST "tar -xvf $REMOTE_FOLDER/../$CONTAINER.tar.gz -C $REMOTE_FOLDER"
done  

Test database backup import:

docker run  -v $(pwd)/backup.sql:/docker-entrypoint-initdb.d/backup.sql -it mysql:5.7 mysql -uroot -proot -Dopencart

error during mysql dump

InnoDB: Table flags are 0 in the data dictionary but the flags in file