備份 ： 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)