rap标签存档订阅
mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `xxxxxxxx` at row: xxx
在使用mysqldump导出MySQL数据的时候，你可能会遇到如题所示的错误，具体如下：
解法：
在mysqldump导出的时候添加选项【–max_allowed_packet=512M 】即可。
[……]
- 发表于：
-
作者：
Adamhuan
- 分类： MySQL
- 标签： -, --max_allowed_packet=512M, ，, :, ", /, 12, 18, 2, 21, 4, 5, 6, 7, 8, b, bytes, db, error, MySQL, mysqld, mysqldump, mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `xxxxxxxx` at row: xxx, ping, pre, rap, repo, report, root, s, SQL, table, 使用, 导出, 数据, 添加, 解法, 选项, 错, 错误
- 发表评论: mysqldump: Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `xxxxxxxx` at row: xxx
Ansible Error:【Using a SSH password instead of a key is not possible because Host Key checking is enabled and sshpass does not support this. Please add this host’s fingerprint to your known_hosts file to manage this host.】
- 发表于：
-
作者：
Adamhuan
- 分类： Ansible
- 标签： -, :, ", /, 2, add, AI, Ansible, ansible.cfg, b, cat, CE, cfg, change, check, dd, ED, enable, error, ES, grep, host, Linux, man, node, not support, password, ping, Please add this host's fingerprint to your known_hosts file to manage this host., pre, print, rap, rm, root, s, sg, SSH, use, Using a SSH password instead of a key is not possible because Host Key checking is enabled and sshpass does not support this., word, 修改, 改, 查, 查看, 错, 错误, 问题
- 发表评论: Ansible Error:【Using a SSH password instead of a key is not possible because Host Key checking is enabled and sshpass does not support this. Please add this host’s fingerprint to your known_hosts file to manage this host.】
MySQL：函数、存储过程、视图
在MySQL中，函数、存储过程和视图都存放在系统库中，具体如下：
MySQL 5.7
函数与存储过程：可以在两个表中查看：
- mysql.proc
- information_schema.routines
视图：
- information_schema.views
MyS[……]
Linux：反选移动
比方说，你希望将某个目录中的所有文件移动到这个目录中的某个文件夹中，这时候，你就需要用到反选操作了；
具体如下：
如上，就通过反选操作，排除了：a / b / c / d / number，而将其他的所有文件移动到了：number；
[……]