All gists matching topic backup

0 喜歡

0 分支

1 檔案

backup linux

1	#!/bin/bash
2	REMOTE_USER="user"
3	REMOTE_HOST="111.111.111.111"
4	REMOTE_PORT="11"
5	REMOTE_PATH="/"
6	LOCAL_PATH="/path/to/folder"
7
8	rsync -avhzr --delete --progress --rsh="ssh -p${REMOTE_PORT}" "${REMOTE_USER}@${REMOTE_HOST}:${REMOTE_PATH}" --exclude={"/dev/","/proc/","/sys/","/tmp/","/run/","/mnt/","/media/","/lost+found","/swapfile","/boot/"} "${LOCAL_PATH}"

0 喜歡

0 分支

1 檔案

backup database linux restore

1	# BACKUP
2	docker exec -i <container-name> /bin/bash -c "PGPASSWORD=<passwd> pg_dump --username <user> <db-name>" > ~/db.sql
3
4	# RESTORE
5	cat db.sql \| docker exec -i <container-name> psql -U <user> <db-name>