备份语句
mysqldump
--single-transaction -R --events --triggers --master-data=2 -u ${username} -p ${ppasswd} -h127.0.0.1 --databases $DB_NAME gzip > /tmp/${GZ_NAME}.sql.gz
恢复语句
mysql
-uroot
-p 库名
<文件.sql
转载于:https://www.cnblogs.com/hope123/p/11363639.html
