mysql数据切割_MySQL 数据库日志切割脚本

#!/bin/bash

USER=backup

PASS=SaJePoM6BAPOmOFOd7Xo3e1A52vEPE

LOGDIR="/tmp/backup"

DATADIR="/var/lib/mysql"

LOG=mysql.log

LOG_ERROR=mysql_error.log

LOG_SLOW_QUERIES=slow.log

SOCKET="/var/lib/mysql/mysql.sock"

#Number of copies

COPIES=30

SHARDING=$(date -d "yesterday" +"%Y-%m-%d")

mkdir -p ${LOGDIR}/${SHARDING}

while read logfile age

do

mv ${DATADIR}/$logfile ${LOGDIR}/${SHARDING}

done << EOF

${LOG}

${LOG_ERROR}

${LOG_SLOW_QUERIES}

EOF

mysqladmin -u${USER} -p${PASS} --socket=${SOCKET} flush-logs

find $LOGDIR -type f -ctime +$COPIES -delete