备份 ： mysqldump -u root -p --databases mysql > 1.sql mysqldump -u user -p --databases dbname > 1.sql ------ 逻辑导出 mysqldump -uroot -proot --databases dbname --add-drop-table=false --extended-insert=false > /tmp/2.sql 导入 ： [https://www.runoob.com/mysql/mysql-database-import.html](https://www.runoob.com/mysql/mysql-database-import.html) [https://www.cnblogs.com/regit/p/8041762.html](https://www.cnblogs.com/regit/p/8041762.html) 开启详细日志 --------------- [https://www.cnblogs.com/chenqionghe/p/9901576.html](https://www.cnblogs.com/chenqionghe/p/9901576.html)