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.
#
mysqldump -utmp -ptmp -h127.0.0.1 -P3307 --single-transaction --master-data=2 --all-databases > 3307_20191123.sql
mysql5.7上使用mysqldump
标签:col mysqld you wan code font master word command