MariaDB + Phpmyadmin + Docker: Running Local Database

I will get MariaDB and Phpmyadmin running in a docker container. I will reuse folder setup and all files from previous recipe - 02.

Source files can be found here:

1. Modify docker-compose.yml file

Here I do several things:

create volume -
```
mariadb-data
```
. This is where all db data will be stored, even if container is restarted, data will be there.
environment variable
```
MYSQL_ROOT_PASSWORD: qwerty
```
- sets root password for mariadb container.
environment variable
```
PMA_ARBITRARY=1
```
- adds "server" input field to phpmyadmin login page (this way you can use this phpmyadmin with an external MySQL DB, and not just this local setup)
environment variable
```
PMA_HOST=mariadb
```
- told phpmyadmin how to connect to mariadb
map ports for
```
phpmyadmin - 8000:80
```
- this maps inner port 80 from inside the container, to port 8000 on my host machine
"
```
depends_on
```
" - prevents container to start before other container, on which it depends

docker-compose up -d

I can go to:

myapp.loc/

- and still see phpinfo page

myapp.loc:8000

- see phpmyadmin, I can login using root/qwerty credentials

This can be achieved by modifying

mariadb

section with:

command: "mysqld --init-file /data/application/init.sql"

and

volumes:
    - ./init.sql:/data/application/init.sql

```
init.sql
```
- is an existing DB dump.
using volumes I copy this file to container's
```
/data/application/init.sql
```
location
using "
```
mysqld --init-file
```
" command - I tell mysql to start and import init.sql

To see list of containers and learn container id or name of mariadb container:

docker container ls

To import:

docker exec -i docker_mariadb_1 mysql -uroot -pqwerty DB_NAME < your_local_db_dump.sql

To export:

docker exec -i docker_mariadb_1 mysqldump -uroot -pqwerty DB_NAME > your_local_db_dump.sql