#!/bin/sh purge_master_logs() { TARGET_DATE=`date -v -3d +\%Y-\%m-\%d` cat <<- EOF PURGE MASTER LOGS BEFORE '$TARGET_DATE 00:00:00'; EOF } purge_master_logs | mysql -hhostname -uusername -ppassword
#!/bin/sh purge_master_logs() { cat <<- EOF PURGE MASTER LOGS BEFORE date_sub(now(), interval '3' day); EOF } purge_master_logs | mysql -hhostname -uusername -p