mysq row格式binlog日志转成sql

mysqlbinlog --base64-output=decode-rows -v ./mysql-bin.xxxx --result-file=xxx.sql # 按时间点导出 mysqlbinlog --start-datetime="2024-05-28 15:40:07" --stop-

trx trx Published on 2024-08-12

kms激活windows server 2022

github下载kms服务端:Releases · Wind4/vlmcsd (github.com) 服务端运行kms server服务:./vlmcsd-x64-musl-static 安装标准版kms密钥:slmgr /ipk VDYBN-27WPP-V4HQT-9VMD4-VMK7H 安装w

trx trx Published on 2024-08-12

windows开启文件加密功能

fsutil behavior set disableencryption 0

trx trx Published on 2024-08-12

fail2ban配置sshd策略

git clone https://github.com/fail2ban/fail2ban.git cd fail2ban sudo python3 setup.py install cp files/redhat-initd /etc/rc.d/init.d/fail2ba sed -i 's

trx trx Published on 2024-08-12

查询Mysql库表大小

SELECT table_schema AS 'Database', table_name AS 'Table', ROUND((data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)' FROM information_schema.

trx trx Published on 2024-08-12

nginx日志配置为json格式

需要注意符号为英文 log_format main escape=json '{' '"客户端IP": "$remote_addr",' '"认证用户": "$remote_user",'

trx trx Published on 2024-08-06

删除以#号和空格#号开头的内容

cat harbor.yml.tmpl | sed '/^[[:space:]]*#\|^[[:space:]]*$/d' >harbor.yml

trx trx Published on 2024-07-19

openeuler添加证书信任

cp certs.crt /etc/pki/tls/certs/ update-ca-trust

trx trx Published on 2024-07-18

国内docker镜像仓库地址

AtomHub 可信镜像仓库平台 :https://hub.atomgit.com/

trx trx Published on 2024-07-12

harbor创建https证书

生成ca证书 openssl genrsa -out ca.key 4096 openssl req -x509 -new -nodes -sha512 -days 3650 \ -subj "/C=CN/ST=guangdong/L=shenzhen/O=tangrongxing/OU=tr

trx trx Published on 2024-07-10
Previous Next