pumpkinseed/dumper repository overview

⁠dumper

Automated SQL dumper with plugable storage system

⁠Usage

⁠Required environment variables

• DB_HOST=127.0.0.1 or mysql.company.com or whatever
• DB_USER=user
• DB_PASSWORD=password
• DB_NAME=db_test
• DUMPER_DUMP_DIR=temporary location of the dump
• DUMPER_ENV=environment of system, require to generate the name of dump
• DUMPER_BACKEND=backend use to persist the dump

⁠Use Docker image

docker run pumpkinseed/dumper // ADD THE DETAILS FROM ABOVE

⁠or use docker-compose

  dumper:
    container_name: dumper
    image: pumpkinseed/dumper
    environment:
      DB_HOST: mysql
      DB_USER: user
      DB_PASSWORD: password
      DB_NAME: db_test
      GOOGLE_APPLICATION_CREDENTIALS: '/etc/creds.json'
      DUMPER_ENV: staging
      DUMPER_BACKEND: gcs
      DUMPER_GCP_PROJECT: project
    volumes:
      - ./creds.json:/etc/creds.json

⁠Backends - Google Cloud Storage

⁠Add GOOGLE_APPLICATION_CREDENTIALS

• Add credentials' json as volume
• Set the environment variable about the location. ex.: GOOGLE_APPLICATION_CREDENTIALS=/etc/creds.json

⁠Required environment variables

• DUMPER_GCP_PROJECT=project