import mysql data to kubernetes pod

Question

Does anyone know how to import the data inside my dump.sql file to a kubernetes pod either;

Directly,same way as you dealing with docker containers:

docker exec -i container_name mysql -uroot --password=secret database < Dump.sql

Or using the data stored in an existing docker container volume and pass it to the pod .

Answer 1

Just if other people are searching for this :

kubectl -n namespace exec -i my_sql_pod_name -- mysql -u user -ppassword < my_local_dump.sql