我try 了很多数据库备份脚本，但都做不到.我想每小时备份一次数据库
如果你能为这次行动写一个脚本，告诉我应该做些什么，我会很高兴的？
date=date(d_m_y_H_M_S)
filename="$date".gz
/var/www/vhosts/system/example.com/httpdocs/backups/中超过8天的所有文件"/var/www/vhosts/system/example.com/httpdocs/backup_log.txt"中，该文本将被写入:Backup is created at $("date")
>/dev/null 2>&1个.经过一个又一个小时的工作，我创造了一个如下的解决方案.我复制粘贴给其他可以受益的人.
首先创建一个脚本文件，并授予该文件可执行权限.
# cd /etc/cron.daily/
# touch /etc/cron.daily/dbbackup-daily.sh
# chmod 755 /etc/cron.daily/dbbackup-daily.sh
# vi /etc/cron.daily/dbbackup-daily.sh
然后用Shift+Ins将以下行复制到文件中
#!/bin/sh
now="$(date +'%d_%m_%Y_%H_%M_%S')"
filename="db_backup_$now".gz
backupfolder="/var/www/vhosts/example.com/httpdocs/backups"
fullpathbackupfile="$backupfolder/$filename"
logfile="$backupfolder/"backup_log_"$(date +'%Y_%m')".txt
echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
mysqldump --user=mydbuser --password=mypass --default-character-set=utf8 mydatabase | gzip > "$fullpathbackupfile"
echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
chown myuser "$fullpathbackupfile"
chown myuser "$logfile"
echo "file permission changed" >> "$logfile"
find "$backupfolder" -name db_backup_* -mtime +8 -exec rm {} \;
echo "old files deleted" >> "$logfile"
echo "operation finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
echo "*****************" >> "$logfile"
exit 0
编辑:
mysqldump --user=mydbuser --password=mypass --default-character-set=utf8
--single-transaction mydatabase | gzip > "$fullpathbackupfile"