Révisions pour Backup your project to another server (scp)

anthony a révisé ce gist 1740064541. Aller à la révision

Aucun changement

anthony a révisé ce gist 1740035301. Aller à la révision

Aucun changement

anthony a révisé ce gist 1740033627. Aller à la révision

1 file changed, 106 insertions

quick-backup.sh(fichier créé)

		@@ -0,0 +1,106 @@
1	+	#!/bin/bash
2	+	#####################################################################
3	+	# #
4	+	# Stupidly simple backup script for own projects #
5	+	# #
6	+	# Author: Anthony Axenov (Антон Аксенов) #
7	+	# Version: 1.0 #
8	+	# License: WTFPLv2 More info: https://axenov.dev/?p=1423 #
9	+	# #
10	+	#####################################################################
11	+
12	+	# database credentials ==============================================
13	+
14	+	DBUSER=
15	+	DBPASS=
16	+	DBNAME=
17	+	DBCHARSET="utf8"
18	+
19	+	# date formats ======================================================
20	+
21	+	FMT_DT_DIR="%Y.%m.%d" # 2021.03.19
22	+	FMT_DT_FILE="%H.%M" # 08.24
23	+	FMT_DT_LOG="%H:%M:%S" # 08:24:15.168149413
24	+
25	+	# local storage =====================================================
26	+
27	+	LOCAL_BAK_DIR="/backup/$(date +$FMT_DT_DIR)"
28	+
29	+	# database backup file
30	+	LOCAL_SQL_FILE="$(date +$FMT_DT_FILE)-db.sql.gz"
31	+	LOCAL_SQL_PATH="$LOCAL_BAK_DIR/$LOCAL_SQL_FILE"
32	+
33	+	# project path and backup file
34	+	LOCAL_SRC_DIR="/var/www/"
35	+	LOCAL_SRC_FILE="$(date +$FMT_DT_FILE)-src.tar.gz"
36	+	LOCAL_SRC_PATH="$LOCAL_BAK_DIR/$LOCAL_SRC_FILE"
37	+
38	+	# log file
39	+	LOG_FILE="$(date +$FMT_DT_FILE).log"
40	+	LOG_PATH="$LOCAL_BAK_DIR/$LOG_FILE"
41	+
42	+	log() {
43	+	echo -e "[$(date +$FMT_DT_LOG)] $*" \| tee -a "$LOG_PATH"
44	+	}
45	+
46	+	# remote storage ====================================================
47	+
48	+	REMOTE_HOST="user@example.com"
49	+	REMOTE_BAK_DIR="/backup/$(date +$FMT_DT_DIR)"
50	+	REMOTE_SQL_PATH="$REMOTE_BAK_DIR/$LOCAL_SQL_FILE"
51	+	REMOTE_SRC_PATH="$REMOTE_BAK_DIR/$LOCAL_SRC_FILE"
52	+	REMOTE_LOG_PATH="$REMOTE_BAK_DIR/$LOG_FILE"
53	+
54	+	# start =============================================================
55	+
56	+	echo
57	+	log "Start ----------------------------------------------------------------"
58	+	log "Initialized parameters:"
59	+	log "\tDB_USER\t\t= $DB_USER"
60	+	log "\tDB_NAME\t\t= $DB_NAME"
61	+	log "\tDB_CHARSET\t= $DB_CHARSET"
62	+	log "\tLOCAL_SRC_DIR\t= $LOCAL_SRC_DIR"
63	+	log "\tLOCAL_SRC_PATH\t= $LOCAL_SRC_PATH"
64	+	log "\tLOCAL_SQL_PATH\t= $LOCAL_SQL_PATH"
65	+	log "\tLOG_PATH\t= $LOG_PATH"
66	+	log "\tREMOTE_HOST\t= $REMOTE_HOST"
67	+	log "\tREMOTE_SQL_PATH\t= $REMOTE_SQL_PATH"
68	+	log "\tREMOTE_SRC_PATH\t= $REMOTE_SRC_PATH"
69	+	log "\tREMOTE_LOG_PATH\t= $REMOTE_LOG_PATH"
70	+
71	+	mkdir -p $LOCAL_BAK_DIR
72	+	log "Created local dir: $LOCAL_BAK_DIR"
73	+
74	+	ssh $REMOTE_HOST mkdir -p $REMOTE_BAK_DIR
75	+	log "Created remote dir: $REMOTE_BAK_DIR"
76	+
77	+	log "1/4 Dumping DB: $DBNAME..."
78	+	mysqldump \
79	+	--user="$DBUSER" \
80	+	--password="$DBPASS" \
81	+	--default-character-set="$DBCHARSET" \
82	+	--opt \
83	+	--quick \
84	+	"$DBNAME" \| gzip > "$LOCAL_SQL_PATH"
85	+	# --opt Same as --add-drop-table, --add-locks, --create-options,
86	+	# --quick, --extended-insert, --lock-tables, --set-charset,
87	+	# and --disable-keys
88	+	[ $? -gt 0 ] && log "ERROR: failed to create dump. Exit-code: $?" \|\| log "\t- OK"
89	+
90	+	log "2/4 Sending database backup to $REMOTE_HOST..."
91	+	rsync --progress "$LOCAL_SQL_PATH" "$REMOTE_HOST:$REMOTE_SQL_PATH"
92	+	[ $? -gt 0 ] && log "ERROR: failed to send database backup. Exit-code: $?" \|\| log "\t- OK"
93	+
94	+	log "3/4 Compressing project dir: $LOCAL_SRC_DIR..."
95	+	tar -zcf "$LOCAL_SRC_PATH" "$LOCAL_SRC_DIR"
96	+	[ $? -gt 0 ] && log "ERROR: failed to compress project. Exit-code: $?" \|\| log "\t- OK"
97	+
98	+	log "4/4 Sending project backup to ${REMOTE_HOST}..."
99	+	rsync --progress "$LOCAL_SRC_PATH" "$REMOTE_HOST:$REMOTE_SRC_PATH"
100	+	[ $? -gt 0 ] && log "ERROR: failed to send project backup. Exit-code: $?" \|\| log "\t- OK"
101	+
102	+	rsync --progress "$LOG_PATH" "$REMOTE_HOST:$REMOTE_LOG_PATH"
103	+
104	+	log "Finish!"
105	+	log "Used space: $(du -h "$LOCAL_BAK_DIR" \| tail -n1)"
106	+	log "Free space: $(df -h \| tail -n1 \| awk '{print $4}')"

Plus récent Plus ancien