docker-compose mysql persistent data

Question

I'm new to docker and I'm following this guide to setup my mac (the guide is for linux but is not the point) for a PHP dev env with docker-compose. The guide is quite good and everything seems to work correctly, there is just a part that doesn't seem to work.

If you go to Step 9 — Creating a User for MySQL, I'm running docker-compose up and I have these errors so I can't access the db container.

mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
db           | 2020-04-16T18:22:19.603226Z 0 [ERROR] [MY-010095] [Server] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
db           | 2020-04-16T18:22:19.603246Z 0 [ERROR] [MY-010119] [Server] Aborting

If I remove the - ./mysql/my.cnf:/etc/mysql/my.cnf from the volumes everything seem to work but then for some reason my laravel db is not created.

these command is not supposed to already create a DB?

environment:
  MYSQL_DATABASE: laravel
  MYSQL_ROOT_PASSWORD: root

another question is where the data is stored?

db:
...
volumes:
  - dbdata:/var/lib/mysql
...

#Volumes
volumes:
  dbdata:
    driver: local

how it works that driver local and what is the location of it?

DevWizard · Accepted Answer · 2020-04-17 10:53:35Z

2

I just found out that the tutorial uses a wrong path, the correct path is:

- ./mysql/my.cnf:/etc/my.cnf

and not:

- ./mysql/my.cnf:/etc/mysql/my.cnf

answered Apr 17, 2020 at 10:53

DevWizard

6971 gold badge14 silver badges40 bronze badges

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

Comments

deivylara · Accepted Answer · 2020-08-27 22:24:25Z

0

docker-compose.yml

version: '3.7' services: db: image: mysql:8.0.21 container_name: dbweb restart: always environment: MYSQL_ROOT_PASSWORD: 'deivypassword' TZ: America/New_York ports: # : < MySQL Port running inside container> - '3306:3306' # Where our data will be persisted volumes: - dbweb2:/var/lib/mysql - ./my.cnf:/etc/mysql/my.cnf

Names our volume

volumes: dbweb2:

answered Aug 27, 2020 at 22:24

deivylara

1

1 Comment

agentsmith Over a year ago

Hi and welcome to SO. Please go through guidlines how to ask, answer and format your content.

Collectives™ on Stack Overflow

docker-compose mysql persistent data

2 Answers 2

Comments

Names our volume

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Names our volume

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related