1.读取sheet页【原始数据】中的B列只取唯一值,并将维一值写入到sheet页【批量处理】A列中 Subonly_data() DimmRng$,D,c SetD=CreateObject("scripting.dictionary")'因MSSQL防注入安全问题，这里的Create与Object之间是没有空格才是正确 ForEachcInSheets("原始数据").Range("B2:B9999") IfNotD.exists(c.Value)ThenD.Addc.Value,"" Nextc Sheets("批量处理").Range("

部署环境: Centos7.6 Zabbix4.4.0 部署前环境准备或清理: 关闭SeLinux vi/etc/selinux/config SELINUX=disabled yumremovemariadb rm-rf/etc/my.cnf rm-rf/var/lib/mysql/ 一.zabbix监控主机的安装 1、安装apache yuminstall-yhttpd httpd服务开机进行自启 systemctlenablehttpd Createdsymlinkfrom/etc/sy

1.误删除,如上图数据 2.马上进入mysql,输入以下命令,重新创建新的日志文件mysql-bin.000002,则误删的记录就保留在旧日志文件mysql-bin.000001中,如下图 mysql>FLUSHLOGS; cp/app/mysql/data/mysql-bin.000001/opt/tmp 3.cd/opt/tmp,用mysqlbinlog导出相应误删的时间段内的删除记录

下载:zabbix-releaseforUbuntu18 wgethttps://repo.zabbix.com/zabbix/4.2/ubuntu/pool/main/z/zabbix-release/zabbix-release_4.2-2%2Bbionic_all.deb sudoaptinstall./zabbix-release_4.2-2+bionic_all.deb sudoaptupdate sudoaptinstallzabbix-server-mysqlzabbix-frontend-phpzabbix-agent vi/etc/apache2/conf-en