mysqldump

mysqldump -h ←host→ --skip-lock-tables --skip-add-locks --no-data -u ←user→ -p ←db name→ > dump.sql

# inside docker container
mysqldump --skip-lock-tables --skip-add-locks --no-data -u root --password=root ←db name→ > dump.sql

# this one somehow does not work on a host machine
docker-compose -f docker-compose.yml exec mysql /usr/bin/mysqldump --no-data --skip-lock-tables --skip-add-locks -u root --password=root ←db name→ > dump.sql

mysqldump -h ←host→ --skip-lock-tables --skip-add-locks --no-data -u ←user→ -p ←db name→ > dump.sql

# inside docker container

mysqldump --skip-lock-tables --skip-add-locks --no-data -u root --password=root ←db name→ > dump.sql

# this one somehow does not work on a host machine

docker-compose -f docker-compose.yml exec mysql /usr/bin/mysqldump --no-data --skip-lock-tables --skip-add-locks -u root --password=root ←db name→ > dump.sql

on k8s pod you can run this:

apt-get install default-mysql-client
mysqldump --skip-lock-tables --skip-add-locks -h [some host] -u [user] --password=[pass] [db_name] > dump.sql

1 2	apt-get install default-mysql-client mysqldump --skip-lock-tables --skip-add-locks -h [some host] -u [user] --password=[pass] [db_name] > dump.sql

mysqldump

Similar Posts

LEAVE A COMMENT Отменить ответ