Skip to content

Instantly share code, notes, and snippets.

@JNajera

JNajera/docker_export.sh

Last active August 25, 2020 21:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save JNajera/82decd72cb9286e982db286a7ba7ded0 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save JNajera/82decd72cb9286e982db286a7ba7ded0 to your computer and use it in GitHub Desktop.
Download ZIP
Docker Expoert and Import DB Mysql
Raw
docker_export.sh
# Backup
docker exec $(docker ps | grep "mysql" | awk '$6 >= 8 {print $1}') /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
Raw
docker_restore.sh
# Restore
cat backup.sql | docker exec -i $(docker ps | grep "mysql" | awk '$6 >= 8 {print $1}') /usr/bin/mysql -u root --password=root DATABASE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment