Database reset in Docker after power down

@monstajamss You need to setup a persistent volume. Checkout

https://tecadmin.net/docker-compose-persistent-mysql-data/

or

https://stackoverflow.com/questions/48182698/mounting-volumes-with-docker-compose

@tippin i figured i had this in my docker.yml

  mysql:
    image: mysql:5.7.22
    container_name: mysql
    restart: unless-stopped
    tty: true
    ports: 
      - "4306:3306"
    volumes:
      - ./mysql:/ar/lib/mysql
    environment:
      MYSQL_DATABASE: homestead
      MYSQL_USER: homestead
      MYSQL_PASSWORD: secret
      MYSQL_ROOT_PASSWORD: secret
      SERVICE_TAGS: dev
      SERVICE_NAME: mysql
    networks: 
      - laravel

instead of

  mysql:
    image: mysql:5.7.22
    container_name: mysql
    restart: unless-stopped
    tty: true
    ports: 
      - "4306:3306"
    volumes:
      - ./mysql:/var/lib/mysql
    environment:
      MYSQL_DATABASE: homestead
      MYSQL_USER: homestead
      MYSQL_PASSWORD: secret
      MYSQL_ROOT_PASSWORD: secret
      SERVICE_TAGS: dev
      SERVICE_NAME: mysql
    networks: 
      - laravel

But how can i run php artisan migrate in my laravel folder instead of docker-compose exec php php /var/www/html/artisan migrate

@monstajamss Not entirely sure why you have the php - folders - artisan php /var/www/html/artisan migrate. But in your docker compose you should designate your main laravel app as a service, then just docker-compose exec app php artisan:migrate . If you really do not like typing all of that, you can always make an alias in your terminal.

Digital ocean has a decent tutorial as well:

https://www.digitalocean.com/community/tutorials/how-to-containerize-a-laravel-application-for-development-with-docker-compose-on-ubuntu-18-04