# 备份
mysqldump -u'username' -p'password' -x dbname > /home/backup/mysql/dbname_$(date +%Y%m%d%H%M%S).sql
# 还原
mysql -u'username' -p'password' dbname < /home/backup/mysql/dbname_20220926112910.sql
# 备份
mysqldump -u'username' -p'password' -x dbname > /home/backup/mysql/dbname_$(date +%Y%m%d%H%M%S).sql
# 还原
mysql -u'username' -p'password' dbname < /home/backup/mysql/dbname_20220926112910.sql