当前位置: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   

人气教程排行