Skip to content

Instantly share code, notes, and snippets.

@mipmip

mipmip/gist:048df12ad2f6c22ba6e8db4ee6eb005e

Created April 22, 2022 09:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mipmip/048df12ad2f6c22ba6e8db4ee6eb005e to your computer and use it in GitHub Desktop.
Save mipmip/048df12ad2f6c22ba6e8db4ee6eb005e to your computer and use it in GitHub Desktop.
Download ZIP
docker-mysq-exec-on-liner
Raw
gistfile1.txt
export $(cat .env | xargs) && docker-compose exec -T mysql mysql -p$MYSQL_PASS <<< "show databases\G"
@mipmip
Copy link
Author

mipmip commented Apr 22, 2022

reads .env for password and forward command into the mysql that run inside a docker container

@mipmip
Copy link
Author

mipmip commented Apr 22, 2022

also handy for importing and exporting:

# EXPORT
export $(cat .env | xargs) && docker-compose exec -T mysql mysqldump -uroot -p$MYSQL_PASS \
      --skip-comments --databases powerdns powerdnsadmin > /tmp/powerdnsdump.sql

# IMPORT
export $(cat .env | xargs) && docker-compose exec -T mysql mysql -p$MYSQL_PASS < /tmp/powerdnsdump.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment