写一个shell mysql备份脚本

#!/bin/bash# Set default file name
FILE=backup.sql# Get the current date and time
NOW=$(date +"%Y-%m-%d-%H-%M")# Set file name
FILE="${FILE}-${NOW}.sql"# Create a backup
mysqldump --user=USERNAME --password=PASSWORD DATABASE > $FILE