Install an sql dump file to a docker container with mariaDB

Question

I am just learning the basics of docker, but have come stuck on importing an SQl file from the local system. I am on windows 10 and have allowed my docker containers to access my shared drives. I have an SQL file located on D i would like to import to the base image of Maria DB i got from docker hub.

I have found a command to install that sql file on my image and tried to directly import the image from inside the container sql command prompt, but get a failed to open file error.

Below are the two methods i have tried, but where do i store my sql dump and how do i import it?

Method 1 tried via mysql command line

winpty docker run -it --link *some-mariadb*:mysql --rm mariadb sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'

Then

use *database-created* // previously created

Then

source d:/sql_dump_file.sql

Method 2

docker exec -i my-new-database mysql -uroot -pnew-db-password --force < d:/sql_dump_file.sql

Update 5/12/2016

So after a disappointing weekend of playing around. I currently change the drive to C: drive as there seemed to be some unknown issue i can't debug with getting D: drive to work.

Then i found the inspect command to see what volumes are mounted to a container. I have the following, but i can't import to SQL as it says file does not exist, but it clearly says in docker that it is there and mounted, the SQL file is inside the map_me folder. I created a folder called map_me in the main directory of C:

docker inspect dbcontainer

       "Mounts": 
           [
            {
                "Source": "/map_me",
                "Destination": "/docker-entrypoint-initdb.d/sl_dump_fil‌e.sql",
                "Mode": "",
                "RW": true,
                "Propagation": "rprivate"
            }
           ]

Farhad Farahi · Accepted Answer · 2016-12-02 07:02:05Z

3

I recommend the following:

Mount your sql_dump_file.sql at /docker-entrypoint-initdb.d/ when creating the container. The official MariaDB image will restore it at startup.

docker run -d --name <containername> -v d:/sql_dump_file.sql:/docker-entrypoint-initdb.d/sl_dump_file.sql <environment_variables> <imagename> <startup commands>

answered Dec 2, 2016 at 7:02

Farhad Farahi

40.3k9 gold badges81 silver badges74 bronze badges

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

8 Comments

Paddy Over a year ago

it created the image file, but when i went into the sql, it just has the default mysql tables.

Farhad Farahi Over a year ago

try this one:

docker run -d --name <containername> -v d:\sql_dump_file.sql:/docker-entrypoint-initdb.d/sl_dump_file.sql <environment_variables> <imagename> <startup commands>

Paddy Over a year ago

Same thing again, creates a database with standard MySQL config, but my SQL dump is not there.

Paddy Over a year ago

Is there an easier way or another way of doing this?

Farhad Farahi Over a year ago

the basics are correct, the rest is windows problem, pathing. try enabling file and printer sharing.

|

Paddy · Accepted Answer · 2016-12-07 02:19:12Z

3

So after some tweaking and better understanding, i came to the conclusion after testing, that docker-compose is the way to go. So the first folder contains a my.cnf file that does the configuration, then the other folder which @Farhad identified is used to intilize the .sql file.

version: "2"

services:

    mariadb_a:
        image: mariadb:latest
        ports: 
         - "3306:3306"
        environment:
         - MYSQL_ROOT_PASSWORD=111111
        volumes:
         - c:/some_folder:/etc/mysql/conf.d
         - c:/some_other_folder:/docker-entrypoint-initdb.d

answered Dec 7, 2016 at 2:19

Paddy

8132 gold badges12 silver badges29 bronze badges

Collectives™ on Stack Overflow

Install an sql dump file to a docker container with mariaDB

2 Answers 2

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related