Export MySQL DB dump from Kubernetes container running in a pod

Question

I have a pod running two containers, one of them is mysql container. I want to take dbdump from mysql container running in the pod and save that file dbdump on my system.

So that dbdump is coming out to my system from container running inside a pod

mysqldump --user="user" --password="Password" abc_database > dbdump.sql

use kubectl cp <some-namespace>/<some-pod>:/tmp/foo /tmp/bar kubernetes.io/docs/reference/generated/kubectl/… — Tarun Khosla
– Tarun Khosla, Commented Jul 20, 2020 at 9:38

Matt · Accepted Answer · 2020-07-20 10:00:09Z

2

kubectl exec the command and redirect the output to a file. The redirection will occur locally on your system

kubectl exec deployment/mysql -- \
  mysqldump --user="user" --password="Password" abc_database > dbdump.sql

answered Jul 20, 2020 at 10:00

Matt

75.8k11 gold badges172 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arghya Sadhu · Accepted Answer · 2020-07-20 10:16:47Z

2

Login into the pod

kubectl exec -it <pod> -n <namespace> -- /bin/bash

Run mysqldump from within the pod and use tmp to write the file

mysqldump <-u user> -p <db> > /tmp/file.sql

Copy the file from the pod

kubectl cp <namespace>/<pod>:/tmp/file.sql file.sql

answered Jul 20, 2020 at 10:16

Arghya Sadhu

45.2k10 gold badges100 silver badges123 bronze badges

Collectives™ on Stack Overflow

Export MySQL DB dump from Kubernetes container running in a pod

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related