23 lines
579 B
Bash
Executable File
23 lines
579 B
Bash
Executable File
#!/bin/bash
|
|
|
|
LOCK="/usr/scheduler/backup-mysql.lock"
|
|
if [ -f "$LOCK" ]; then
|
|
echo "Another instance of $0 is running, exiting..."
|
|
exit 1
|
|
fi
|
|
|
|
touch $LOCK # Creates the file
|
|
trap "rm $LOCK" EXIT
|
|
|
|
echo "Beginging backup of DB_1..."
|
|
|
|
FILE=/srv/backup
|
|
if [ -f "/srv/backup/sql/db_1.sql.gz" ]; then
|
|
echo "Rotating existing backup files..."
|
|
logrotate /usr/scheduler/logrotate_backup_sql
|
|
fi
|
|
|
|
echo "Dumping datbase DB_1..."
|
|
mariadb-dump --skip-ssl --opt -h localhost -u root -p$MARIADB_ROOT_PASSWORD db_1 | gzip -c > /srv/backup/sql/db_1.sql.gz
|
|
echo "Backup finished!"
|