写一个脚本

用于自动化备份MySQL数据库。 #!/bin/bash #This script is used to backup the MySQL database automatically. # Set MySQL user and password MYSQL_USER="root" MYSQL_PASSWORD="password" # Set the backup directory path BACKUP_DIR="/home/mysqlbackup" # Please create this directory manually before running this script. DATE=`date +%Y-%m-%d` # Get the current date. # Create a new directory using the current date in the backup directory for storing the current date backup. mkdir -p $BACKUP_DIR/$DATE # Backup all databases with mysqldump command. mysqldump --user=$MYSQL_USER --password=$MYSQL_PASSWORD --all-databases > $BACKUP_DIR/$DATE/alldb-$DATE.sql # Compress all databases backup file with gzip command. gzip $BACKUP_DIR/$DATE/alldb-$DATE.sql