Skip to main content

Backup ;)

Backup MySQL

Gerar backup agrupado e compactado

$ docker exec <container> mysqldump -h<srv> -uroot -p <database> | gzip -9 > ~/bkp/$(date +"%Y-%m-%d_%H-%M-%S")_<database>.sql.gz

Backup TAR

Gerar backup agrupado e compactado

$ cd ~/app
$ tar -zcvf n4w3b.tar.gz n4w3b/

Listar conteúdo

$ tar -ztvf n4w3b.tar.gz

Descompactar

$ tar -zxvf n4w3b.tar.gz

Backup Script

MySQL

Script de backup MySQl

backup-db.sh
#! /bin/sh

#
# $ chmod 755 backup-db.sh
# $ ./backup-db.sh <database> <usr> <pwd>
#

cd $(dirname $0)
DB=$1
DBUSER=$2
DBPASSWD=$3
FILE=$(date +"%Y-%m-%d_%H-%M-%S")-$DB.sql
mysqldump --routines "--user=${DBUSER}" --password=$DBPASSWD $DB > $PWD/$FILE
gzip $FILE
echo Created $PWD/$FILE*

Testa acesso

A partir do host

$ curl -L -v localhost

A partir do container

$ docker exec -it sdtm-site_app bash -c "curl -L -v localhost"

Misc

Resetar network quando não está acessível

$ docker network prune -f

Reiniciar wsl

> wsl.exe --shutdown
> Get-Service LxssManager | Restart-Service

Registry

Backup da imagem

$ docker save mattrayner/lamp:latest-1404-php5 > docker-image-lamp5.tar

Restaurar imagem

$ docker load < docker-image-lamp5.tar

Limpar imagens

$ docker exec -it registry bin/registry garbage-collect /etc/docker/registry/config.yml --delete-untagged=true
$ df -h /
$ du -chs ~/infra/registry/*