KoMiToRaY/create db with docker.md

## create db with docker.md

      
    Raw
  

              create db with docker.md
            
          
    Créer une base de données sous docker

Create docker instance

docker run -d -p 3303:3306 -v ~/Workspace/databases/dadb:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=admin --name dadb mariadb:10.0.38
Create and Import db

docker exec -i dadb mysql -uroot -padmin < ~/Téléchargements/mpf_demarches_administratives.sql
If db no exist create the db in mysql

1. Go to our mysql

docker exec -it dadb mysql -uroot -p
2. Create the db

CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
3. Now import the db

docker exec -i dadb mysql -uroot -padmin mpf_demarches_administratives < ~/Téléchargements/mpf_demarches_administratives.sql