找回密码
 注册
查看: 4136|回复: 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
* d6 K0 ]7 P3 pWarning: Using a password on the command line interface can be insecure.
- M, ?% @; d$ K9 o8 y; m. ^# [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.
% H9 u- c! }1 a  J6 g
( Z$ e- f1 g" K' z1 M7 J) W. F% K# v* L! I) b, d
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2026-6-12 02:05 , Processed in 0.022132 second(s), 25 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

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