MySQL 备份与还原
1
2
3
4
5
# 备份
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
本文由作者按照
CC BY 4.0
进行授权