mirror of https://git.envs.net/envs/ops.git
46 lines
1.1 KiB
Bash
Executable File
46 lines
1.1 KiB
Bash
Executable File
#!/usr/bin/env bash
|
|
|
|
CMD="$1"
|
|
DB="$2"
|
|
BACKUP_DIR="/home/$USER/backup"
|
|
|
|
print_usage() {
|
|
printf 'envs.net | mysql backup & restore\n\n'
|
|
printf 'Usage: %s\n\t backup\t\t\t - backup your default user database (%s)\n' "$(basename "$0")" "$USER"
|
|
printf '\t backup <db_name>\t - backup database\n'
|
|
printf '\t restore\t\t - restore your latest user database\n'
|
|
printf '\t restore <db_name>\t - restore database\n'
|
|
}
|
|
|
|
backup() {
|
|
[ -z "$DB" ] && DB="$USER"
|
|
test ! -d "$BACKUP_DIR" && mkdir -p "$BACKUP_DIR" && chmod 700 "$BACKUP_DIR"
|
|
|
|
mysqldump -u "$USER" "$DB" -p | gzip -c > "$BACKUP_DIR"/db_"$(date +%F.%H%M%S)".sql.gz
|
|
find "$BACKUP_DIR"/db_*.gz -maxdepth 1 -type f -mtime +7 -delete
|
|
}
|
|
|
|
restore() {
|
|
if [ -z "$DB" ]; then
|
|
latest=''; for f in "$BACKUP_DIR"/db_*.gz; do [ "$f" -nt "$latest" ] && latest="$f"; done
|
|
[ -z "$latest" ] && printf 'no restore file found in %s!\n' "$BACKUP_DIR" && exit 0
|
|
DB="$latest"
|
|
gunzip < "$DB" | mysql -u "$USER" "$USER" -p
|
|
else
|
|
gunzip < "$BACKUP_DIR"/"$DB" | mysql -u "$USER" "$DB" -p
|
|
fi
|
|
}
|
|
|
|
[ $# -lt 1 ] && print_usage && exit 1
|
|
|
|
case "$CMD" in
|
|
backup*) backup;;
|
|
|
|
restore*) restore;;
|
|
|
|
*) print_usage;;
|
|
esac
|
|
|
|
#
|
|
exit 0
|