Warning: Using a password on the command line interface can be insecure.

简介: <p><span style="color:#3366ff">做全备份不要使用名文,在命令行</span></p> <p>[root@t2 ~]# mysqldump -uroot -pjsb --lock-all-tables --master-data=2 --events --routines --all-databases > /tmp/database_`date +%F

做全备份不要使用名文,在命令行

[root@t2 ~]# mysqldump -uroot -pjsb --lock-all-tables --master-data=2 --events --routines --all-databases > /tmp/database_`date +%F`.sql

Warning: Using a password on the command line interface can be insecure.



[root@t2 ~]# mysqldump -uroot -p --lock-all-tables --master-data=2 --events --routines --all-databases > /tmp/database_`date +%F`.sql

Enter password: 

[root@t2 ~]# ls /tmp/

解析:

–lock-all-tables表示为所有表施加读锁;

–master-data=2表示在备份文件中记录当前二进制日志的位置;

–events表示备份数据的同时备份时间调度器代码;

–routines表示备份数据的同时备份存储过程和存储函数;

–all-databases表示备份所有库。

目录
相关文章
|
11月前
|
关系型数据库 MySQL 数据安全/隐私保护
已解决:mysql: [Warning] Using a password on the command line interface can be insecure.
已解决:mysql: [Warning] Using a password on the command line interface can be insecure.
751 0
|
12月前
|
网络安全
完美解决 WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!
完美解决 WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!
2931 0
|
Java
解决Command line is too long. Shorten command line for ServiceStarter or also for Application报错
解决Command line is too long. Shorten command line for ServiceStarter or also for Application报错
429 0
|
安全 关系型数据库 MySQL
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: [Warning] Using a password on the command line interface can be insecure.
Error running 'XXXApplication': Command line is too long. Shorten command line forXXX
Error running 'XXXApplication': Command line is too long. Shorten command line forXXX
183 0
Error running 'XXXApplication': Command line is too long. Shorten command line forXXX
Command line is too long. Shorten command line for AppWebStarter or...(已解决)
找到你项目中 .idea/workspace.xml文件 找到 < component name=“PropertiesComponent” > 在标签内部加上这句
185 0
Command line is too long. Shorten command line for AppWebStarter or...(已解决)
|
数据安全/隐私保护
Give root password for maintenance(or type control -D to continue)
2017-09-30 18:12:08 1:错误如图,本来开机准备用一下虚拟机,就出现一个这,为啥记录一下呢,因为网上好多不是很靠谱。 原因可能是之前关闭虚拟机的时候不小心出现异常了: 2:解决办法:   个人根据自己的磁盘分区情况,进行修复即可; 解决方法,在鼠标停留的地方输入...
1899 0