Guest User

Untitled

a guest
May 26th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. #Dump
  2. docker exec <sqlcontainer> sh -c 'exec mysqldump --all-databases -uroot -p"$MYSQL_ROOT_PASSWORD"' > /path/all-databases.sql
  3.  
  4. #Restore1
  5.  
  6. docker exec -i <sqlcontainer> sh -c 'mysql -uroot -p"$MYSQL_ROOT_PASSWORD" <database>' < /path/just_mautic.sql
  7.  
  8. #Restore2
  9. cat /path/just_mautic.sql | docker exec -i <sqlcontainer> /usr/bin/mysql -u root --password=<password> <database>
  10.  
  11. # run client
  12. docker run -it --link <sqlcontainer>:mysql --rm mysql sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'
Add Comment
Please, Sign In to add comment