当前位置:Gxlcms > 数据库问题 > mysql5.7上使用mysqldump

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   

人气教程排行