MySQL DBA - Tips and Techniques Magazine

MySQL DBA - Tips and Techniques Magazine

13 Nov 2014

Example of daily deletion of a table via crontab

00 08 * * * mysql -uroot -p*** -se 'delete from tacacs.accounting where date < date_sub(now(), interval 90 day);'  > /tmp/delete_accounting.log 2>&1

Posted by at

1 comment:

  1. Daniël van Eeden15 November 2014 at 11:49

    This could also be done with the MySQL event scheduler
    http://dev.mysql.com/doc/refman/5.6/en/events.html

    ReplyDelete

Subscribe to: Post Comments (Atom)