linux/mac 实用脚本

知识

set -ex: -e:命令失败后立即结束 -x:打印每条执行的命令

mysqldump

MySQL mysqldump数据导出详解 复制表,调用方式:sh copy.sh "-h127.0.0.0 -uroot -P8306 -p123456 boss_develop"

#!/bin/bash
#set -x
REMOTE_HOST=$1
echo REMOTE_HOST:$REMOTE_HOST


oldifs=$IFS
dump(){
# -C启用压缩 --skip-triggers 不导出触发器
mysqldump -h10.69.34.205 -uadmin -P9800 -pDc@20120225 --opt -C boss $1 | mysql $REMOTE_HOST
}
dtd(){
        IFS=$oldifs
        arr=($1)
        for table in ${arr[@]}
        do
            echo start dump $table
            dump $table
        done
        IFS=$'\n'
}

IFS=$'\n'

#crm_measurement_units  crm_department crm_role_extend crm_price_item_ref_measure_time crm_time_units
#crm_special_rules_item crm_special_rules_product_item_rel crm_special_rules_product_type_rel
#dw_manual_rule dw_slice_rule
#crm_account_director crm_employee crm_region_base

tables="
crm_product_type crm_product_line_group
crm_account crm_contract contract_account_release crm_product_type_relation contract_product_price
crm_price_definition crm_price_detail
crm_special_rules_discount crm_contract_sprules crm_contract_sprules_regions
crm_rule_use_log crm_rule_use_lock crm_manual_rule crm_manual_rule_lock
month_bill_locked month_bill_summary_new
"

for table in ${tables[@]}
do
        read -r -p $table" ? [Y/n] " input
        case $input in
                [yY][eE][sS]|[yY]) dtd "${table}" ;;
                *) echo "No";;
        esac
done

IFS=$oldifs

echo finish copy
read

部署ss服务器教程

阿里云搭建SS代理超详细教程!!! - 天涯小嘿嘿 - 博客园 脚本来源:teddysun/shadowsocks_install

服务状态检测

ssl证书过期检测

实用命令

获取父线程名称 get the name of the caller script in bash script

简单for循环curl测试下载速度/for循环写成一行 参考:linux脚本

Last updated

Was this helpful?