Linux 常用命令

1、###

// <editor-fold defaultstate="collapsed" desc="===== 折叠 ======">
// </editor-fold>

2、### mysql

ALTER TABLE consultation add COLUMN `apply_by_stat` BIGINT(20) null DEFAULT 0 COMMENT '申请人(统计用)' AFTER apply_by ;
update consultation set apply_by_stat= if(apply_by REGEXP '^[0-9]+$'=1,CONVERT(apply_by,SIGNED),0) ;
ALTER TABLE consultation ADD INDEX index_apply_by_stat(apply_by_stat) ;
show index from consultation ;

2、###

mysqldump -uroot -pxxxxxxx aaaa > /root/tools/20230718.sql
./ossutil64 cp -r /root/tools/1.zip oss://yyyyy-blck/deployment_temp_files/ --update --disable-all-symlink
mysql -uroot -proot aaaa_local_test1 --default-character-set=utf8mb4 < C:/Users/K/Desktop/20230718.sql
mysql -uroot -proot aaaa_local_test1 --default-character-set=utf8mb4 < C:/Users/K/Desktop/桌面临时/aaaa_2023_11_18_11_14_40.sql

crontab -e
*/2 9-19 * * * cd /root/k/ym2/ && /usr/bin/sh a_admin_auto_git.sh
*/30 0-9 * * * cd /root/k/ym2/ && /usr/bin/sh a_admin_auto_git.sh
*/30 19-23 * * * cd /root/k/ym2/ && /usr/bin/sh a_admin_auto_git.sh
service crond restart

docker run -d -it --name=ym_h5_aaaa -p 10011:49105 -v /data/bbbbb_temp_aaaa/ym_client/bbbbb2-mobile/:/app ym_h5
docker logs -f --tail=300 metersphere-redis
docker logs -f --tail=300 ym_h5_aaaa

docker rm `docker ps -a|grep metersphere|awk '{print $1}'`
docker rmi --force $(docker images | grep ym_h5) 
docker rmi --force `docker images |grep metersphere|awk '{print $3}'`

docker inspect metersphere-mysql

docker exec -it metersphere-mysql bash

zip -r metersphere.bak.2023-07-24.nqct.zip /opt/metersphere/data/

/opt/metersphere/metersphere.bak.2023-07-24.nqct.zip
./ossutil64 cp -r /opt/metersphere/metersphere.bak.2023-07-24.nqct.zip oss://yyyyy-blck/deployment_temp_files/other/ --update --disable-all-symlink
cd /root/k/ossutil64/ && ./ossutil64 cp -r /opt/metersphere/bak.zip oss://yyyyy-blck/deployment_temp_files/other/ --update --disable-all-symlink