Skip to content

Instantly share code, notes, and snippets.

@j-o-lantern0422

j-o-lantern0422/remote_docker_db_backup.sh

Last active December 14, 2019 14:06
Show Gist options
  • Save j-o-lantern0422/c6f2dbdaf04f1c8d70a0907fb00c06dc to your computer and use it in GitHub Desktop.
Save j-o-lantern0422/c6f2dbdaf04f1c8d70a0907fb00c06dc to your computer and use it in GitHub Desktop.
Download ZIP
sshしてdocker-composeで起動してるmysqlのコンテナでmysqldumpして結果をローカルに持ってくるやーつ
Raw
remote_docker_db_backup.sh
#!/bin/bash
filename=$(date "+%Y%m%d")
project_path="/src/project/"
ssh remote.com "bash -lc \"sudo docker-compose -f ${project_path}docker-compose.yml -f ${project_path}production.yml exec db mysqldump -u USER -p PASS DATABASE\" | gzip " | cat > ./dumps/${filename}.dump.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment