mysql5.7上使用mysqldump
时间:2021-07-01 10:21:17
帮助过:6人阅读
.
1 -P3307 --single-transaction --master-data=
2 --all-databases >
3307_20191123.sql
mysqldump: [Warning] Using a password on the command line interface can be insecure.
Warning: A partial dump from a server that has GTIDs will by default include the GTIDs of all transactions,
even those that changed suppressed parts of the database. If you don‘t want to restore GTIDs, pass --set-gtid-purged=OFF. To make
a complete dump, pass --all-databases --triggers --routines --events.
#
- <span style="font-family: Microsoft YaHei; font-size: 18px;"><strong>mysqldump -utmp -ptmp -h127.<span style="color: #800080;">0.0.<span style="color: #800080;">1 -P3307 --single-transaction --master-data=<span style="color: #800080;">2 --all-databases ><span style="color: #000000;"> 3307_20191123.sql</span></span></span></span></strong></span>
mysql5.7上使用mysqldump
标签:col mysqld you wan code font master word command