找回密码
 注册
查看: 4133|回复: 0

mysqldump -u root -p --all-databases

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2017-5-27 09:31:37 | 显示全部楼层 |阅读模式
# mysqldump -u root -p --all-databases > all.sql- a0 \% m0 i4 ]7 ~
Warning: Using a password on the command line interface can be insecure.
/ _7 i8 |' P( n$ C' G, A6 t' SWarning: 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.
* f, n4 c! z- v# |9 w1 R& u- ~- a, m* I/ n1 O) F8 l7 T
& I  A3 T( m& B) X
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 00:03 , Processed in 0.024089 second(s), 25 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表