共计 506 个字符，预计需要花费 2 分钟才能阅读完成。
写一个 shell 脚本，用来备份数据库
#!/bin/bash
# This is a shell script to backup MySQL database
# MySQL database details
user="root"
password="yourpassword"
host="localhost"
db_name="yourdbname"
# Other options
backup_path="/opt/backups/"
date=$(date +"%d-%b-%Y")
# Set default file permissions
umask 177
# Dump database into SQL file
mysqldump –user=$user –password=$password –host=$host $db_name > $backup_path/$db_name-$date.sql
# Delete files older than 30 days
find $backup_path/* -mtime +30 -exec rm {} ;
这脚本写的比我好多了
^-^ 太繁琐了 我一条命令搞定
正文完
