Skip to content

Instantly share code, notes, and snippets.

View yangyang5214's full-sized avatar
🎯
Focusing

beer yangyang5214

🎯
Focusing
View GitHub Profile
@yangyang5214
yangyang5214 / kill_todesk.md
Created May 5, 2023 05:55
kill todesk_service process. 傻逼软件
@yangyang5214
yangyang5214 / compress_qcow2.sh
Created April 28, 2023 02:26
compress qcow2 file
yum install -y libguestfs-tools-c
virt-sparsify --compress windows_honey_pot_7.qcow2 new_windows_honey_pot_7.qcow2
@yangyang5214
yangyang5214 / ncat_port.md
Created April 27, 2023 11:30
ncat 端口转发
ncat --sh-exec "ncat 55.0.0.13 3389" -l 3389  --keep-open
@yangyang5214
yangyang5214 / network-with-libvirt.md
Created April 26, 2023 02:58
libvirt network create
@yangyang5214
yangyang5214 / mac_软件推荐.md
Last active May 4, 2023 12:20
mac 软件推荐
@yangyang5214
yangyang5214 / mac_navicat.sh
Created April 23, 2023 03:16
Mac 提示文件已损坏解决
```
# 终端运行
xattr -cr /Applications/Navicat\ Premium.app/
```

demo

mysqldump --complete-insert --opt db_name table_name | grep 'INSERT INTO `table_name`' > result.sql
  • --complete-insert 包含列名。用于不同版本间 sql 同步
  • --opt db_name table_name。指定 db table
  • grep。只保留 insert into 语句
@yangyang5214
yangyang5214 / gitlab_add_test_pipeline.md
Last active May 4, 2023 12:22
Gitlab 为 merge request 添加 自动化测试

Gitlab 添加项目的自动化测试

前置

  • gitlabg CI/CD
  • docker
  • gitlab-runner
@yangyang5214
yangyang5214 / centos_install_jq.txt
Last active May 4, 2023 12:19
centos install jq
yum install epel-release -y
yum update -y
yum install jq -y