找回密码
 注册
查看: 4135|回复: 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& M/ p1 S5 M) D5 U
Warning: Using a password on the command line interface can be insecure.
# ~0 b* z+ ~  c0 BWarning: 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.
6 _4 L) Q( E0 }6 S6 r8 g
! h, L, c& W' p6 a6 a$ T  E& D% `4 T6 w# L2 t( c/ O; \9 p  P
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-12 01:00 , Processed in 0.020923 second(s), 23 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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