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 .

Accepted Answer

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
```

import mysql data to kubernetes pod

Solution

Problem