文章

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 进行授权