Paco

Personal Content Organiser

Home / Linux

Navigation

Menu

Search

Export and restore mysql db dump from kubernetes pod

Export database
kubectl exec {{podName}} -n {{namespace}} -- mysqldump -u {{dbUser}} -p{{password}} {{DatabaseName}} > {{FileName}}sql



Export all databases
kubectl exec {{podName}} -n {{namespace}} -- mysqldump -u {{dbUser}} -p{{password}} --all-databases > {{FileName}}.sql


Restore
kubectl exec -it {{podName}} -n {{namespace}} -- mysql -u {{dbUser}} -p{{password}} {{DatabaseName}} < {{FileName}}.sql