Skip to navigation
How to export mysql via docker bash script
10.10.21
#! /bin/bash DB_NAME=foo DB_USER=bar DB_PASSWORD=barbarbar docker run -i --rm --net=host salamander1/mysqldump --verbose -h 127.0.0.1 -u "${DB_NAME//[[:blank:]]/}" -p"${DB_PASSWORD//[[:blank:]]/}" "${DB_NAME//[[:blank:]]/}" | gzip > "init/${DB_NAME//[[:blank:]]/}.sql.gz"
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
Reply
Anonymous
to import #! /bin/bash echo "...import from init" gzip -d -k init/$DB_NAME.sql.gz docker run -i --rm --net=host salamander1/mysql -h 127.0.0.1 --user=foo -pBARBAR foo < init/myridiasql1.sql rm init/myridiasql1.sql
10.10.21
Reply
Anonymous
Information Epoch 1745724981
Think hierarchically.
Home
Notebook
Contact us