#! /bin/bash
# @(#)(CAcert) $Id: mysql-purge-logs,v 1.2 2018/07/30 09:21:51 root Exp $
# mysql-purge-logs - script to purge mysql binary logs older than one year

LOG=/var/log/mysql.log
exec 2>&1 >>${LOG}

YEAR=$(date '+%Y')
PREVYEAR=$((${YEAR} - 1))

CUTOFF=${PREVYEAR}-$(date '+%m-%d %k:%M:%S')

echo "Purging MySQL logs before ${CUTOFF}"
echo "PURGE BINARY LOGS BEFORE '${CUTOFF}'" | mysql --defaults-file=/etc/mysql/debian.cnf