Mac常用sh文件

#!/bin/bash
# MySQL数据库配置
DB_HOST="IP" # MySQL服务器的IP地址
DB_PORT="3306" # MySQL服务器的端口号
DB_USER="root"
DB_PASSWORD="123456"
DB_NAME="DBNAME"
BACKUP_DIR="/Users/yuqiu/dbbackup"
# 要排除的表的前缀
EXCLUDE_PREFIXES=("sys_log_" "bus_log_")
# 获取数据库中的所有表
TABLES=$(mysql -h$DB_HOST -P$DB_PORT -u$DB_USER -p$DB_PASSWORD $DB_NAME -e "SHOW TABLES;" | grep -v "Tables_in_$DB_NAME")
# 排除指定前缀的表
for prefix in "${EXCLUDE_PREFIXES[@]}"; do
    TABLES=$(echo "$TABLES" | grep -v "^$prefix")
done
# 当前日期
DATE=$(date +%Y%m%d_%H%M)
# 备份目录
BACKUP_PATH="$BACKUP_DIR/$DB_NAME-backup-$DATE.sql"
# 备份所有表，排除指定前缀的表
mysqldump -h$DB_HOST -P$DB_PORT -u$DB_USER -p$DB_PASSWORD $DB_NAME $TABLES > $BACKUP_PATH
# 压缩备份文件
gzip $BACKUP_PATH
echo "Backup completed: $BACKUP_PATH.gz"

#!/bin/bash
# MySQL数据库配置
DB_HOST="IP" # MySQL服务器的IP地址
DB_PORT="3306" # MySQL服务器的端口号
DB_USER="root"
DB_PASSWORD="123456"
DB_NAME="DBNAME"
BACKUP_DIR="/Users/yuqiu/dbbackup"
# 要排除的表的前缀
EXCLUDE_PREFIXES=("sys_log_" "bus_log_")
# 获取数据库中的所有表
TABLES=$(mysql -h$DB_HOST -P$DB_PORT -u$DB_USER -p$DB_PASSWORD $DB_NAME -e "SHOW TABLES;" | grep -v "Tables_in_$DB_NAME")
# 排除指定前缀的表
for prefix in "${EXCLUDE_PREFIXES[@]}"; do
    TABLES=$(echo "$TABLES" | grep -v "^$prefix")
done
# 当前日期
DATE=$(date +%Y%m%d_%H%M)
#备份成单个sql文件
#BACKUP_PATH="$BACKUP_DIR/$DB_NAME-backup-$DATE.sql"
# 单个sql文件备份，排除指定前缀的表
#mysqldump -h$DB_HOST -P$DB_PORT -u$DB_USER -p$DB_PASSWORD $DB_NAME $TABLES > $BACKUP_PATH
# 单个sql压缩备份文件
#gzip $BACKUP_PATH
#备份成两个sql文件structure和data
STRUCTURE_BACKUP_PATH="$BACKUP_DIR/$DB_NAME-structure-$DATE.sql"
DATA_BACKUP_PATH="$BACKUP_DIR/$DB_NAME-data-$DATE.sql"
FINAL_BACKUP_PATH="$BACKUP_DIR/$DB_NAME-backup-$DATE.tar.gz"
# 导出表结构
mysqldump -h$DB_HOST -P$DB_PORT -u$DB_USER -p$DB_PASSWORD --default-character-set=utf8mb4 --no-data $DB_NAME $TABLES > $STRUCTURE_BACKUP_PATH
# 导出数据
mysqldump -h$DB_HOST -P$DB_PORT -u$DB_USER -p$DB_PASSWORD --default-character-set=utf8mb4 --no-create-info $DB_NAME $TABLES > $DATA_BACKUP_PATH
# 合并两个SQL文件并压缩
tar -czvf $FINAL_BACKUP_PATH -C $BACKUP_DIR $(basename $STRUCTURE_BACKUP_PATH) $(basename $DATA_BACKUP_PATH)
# 删除临时SQL文件
rm $STRUCTURE_BACKUP_PATH $DATA_BACKUP_PATH
echo "Backup completed: $BACKUP_PATH.gz"

#!/bin/bash
# 定义目标目录
target_dir="/Users/yuqiu/****/"
output_dir="$target_dir/ZIPDIR"
# 获取当前日期
current_date=$(date +"%Y-%m-%d")
# 定义压缩文件名
zip_filename="XX_${current_date}.zip"
# 检查目标目录是否存在
if [ ! -d "$target_dir" ]; then
  echo "目标目录不存在: $target_dir"
  exit 1
fi
# 检查要压缩的目录是否存在
if [ ! -d "$target_dir/needZipFolder1" ] || [ ! -d "$target_dir/needZipFolder2" ]; then
  echo "要压缩的目录不存在"
  exit 1
fi
# 检查并创建输出目录
if [ ! -d "$output_dir" ]; then
  mkdir -p "$output_dir"
  if [ $? -ne 0 ]; then
    echo "无法创建输出目录: $output_dir"
    exit 1
  fi
fi
# 切换到需要压缩文件的目录
cd "$target_dir"
# 创建压缩文件,压缩指定的两个文件夹
zip -r "$output_dir/$zip_filename" "needZipFolder1" "needZipFolder2"
# 检查压缩是否成功
if [ $? -eq 0 ]; then
  echo "压缩成功: $output_dir/$zip_filename"
else
  echo "压缩失败"
  exit 1
fi

#!/bin/bash
# 获取当前日期
current_date=$(date +"%Y-%m-%d")
# 指定文件夹路径
FOLDER_PATH="/Users/yuqiu/log/${current_date}"
# 使用 open 命令打开文件夹
open "$FOLDER_PATH"

#!/bin/bash
# 获取当前日期
current_date=$(date +"%Y-%m-%d")
FILE_PATH="/Users/yuqiu/XX/XX_${current_date}.zip"
# 目标微信用户
TARGET_USER="userWXidNumber"
# AppleScript
osascript <<EOF
tell application "WeChat"
    activate
    delay 2
    -- 打开微信搜索并输入目标用户名字
    tell application "System Events"
        keystroke "f" using {command down}
        delay 1
        keystroke "$TARGET_USER"
        delay 1
        keystroke return
        delay 1
        -- 打开文件发送窗口
        -- keystroke "f" using {command down, shift down}
        -- delay 1
        -- 输入文件路径并发送
        -- set the clipboard to POSIX file "$FILE_PATH" as text
        -- delay 1
        -- keystroke "v" using {command down}
        -- delay 1
        -- keystroke return
        -- delay 1
        -- keystroke return
    end tell
end tell
EOF