mysqldump <db_name> <table_name> --where="extension_id=727" > outfile.sql
version: '3.9'
services:
redmine:
image: redmine:5.0
restart: always
depends_on:
- mysql-redmine
ports:
- 8090:3000
volumes:
- /srv/redmine-files:/usr/src/redmine/files
- /srv/redmine-logs:/var/log/redmine
environment:
- TZ=Europe/Kyiv
- REDMINE_DB_MYSQL=mysql-redmine
# - REDMINE_DB_USER=redmine
# - REDMINE_DB_PASSWORD=somepassword
- REDMINE_DB_PASSWORD=supermegapassword
- REDMINE_SECRET_KEY_BASE=supersecretkey
networks:
redmine:
mysql-redmine:
image: mysql:8.0
restart: always
environment:
- MYSQL_ROOT_PASSWORD=supermegapassword
- MYSQL_DATABASE=redmine
- MYSQL_USER=redmine
- MYSQL_PASSWORD=somepassword
networks:
redmine:
networks:
redmine:
driver: bridge
services:
dind:
image: docker:23-dind
restart: always
privileged: true
environment:
DOCKER_TLS_CERTDIR: ""
command:
- --storage-driver=overlay2
runner:
restart: always
image: registry.gitlab.com/gitlab-org/gitlab-runner:alpine
depends_on:
- dind
environment:
- DOCKER_HOST=tcp://dind:2375
volumes:
- ./config:/etc/gitlab-runner:z
# register-runner:
# restart: 'no'
# image: registry.gitlab.com/gitlab-org/gitlab-runner:alpine
# depends_on:
# - dind
# environment:
# - CI_SERVER_URL=${CI_SERVER_URL}
# - REGISTRATION_TOKEN=${REGISTRATION_TOKEN}
# command:
# - register
# - --non-interactive
# - --locked=false
# - --name=${RUNNER_NAME}
# - --executor=docker
# - --docker-image=docker:20-dind
# - --docker-volumes=/var/run/docker.sock:/var/run/docker.sock
# volumes:
# - ./config:/etc/gitlab-runner:z
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": "s3:*",
"Resource": [
"arn:aws:s3:::mybucket/toto3/*"
]
},
{
"Effect": "Allow",
"Action": [
"s3:ListAllMyBuckets",
"s3:GetBucketLocation"
],
"Resource": "arn:aws:s3:::*"
},
{
"Effect": "Allow",
"Action": "s3:ListBucket",
"Resource": "arn:aws:s3:::mybucket",
"Condition": {
"StringLike": {
"s3:prefix": [
"",
"toto3/",
"toto3*"
]
}
}
}
]
}
https://stackoverflow.com/questions/35944349/iam-aws-s3-to-restrict-to-a-specific-sub-folder