mysql dump (docker)

docker-compose.yml

version: '3.3'
services:
  mysql:
    restart: always
    image: mysql:8.0
    container_name: mysql
    ports:
      - '3306:3306'
      - '33060:33060'
    environment:
      - DEBUG=false
      - MYSQL_DATABASE=baza
      - MYSQL_USER=user
      - MYSQL_PASSWORD=password
      - MYSQL_ROOT_PASSWORD=password
    volumes:
      - ./mysql-datadir:/var/lib/mysql
      - ./:/backup
      - /etc/localtime:/etc/localtime:ro

docker exec -it mysql bash

mysql -u root -p

grant all privileges on *.* to 'user'@'%' with grant option;

mysql -u user -p

mysqldump -u user -p baza > /backup/baza.sql

Dump remote DB:

mysql -u user -p -h127.0.0.1
mysqldump -u user -p -h127.0.0.1 baza > baza.sql