Script allows you to purge old data from kayako database (Kayako helpdesk solution, http:https://kayako.com/).

Usage is pretty easy, you have to run something like this:

    $ mysql -D kayakodb -u dbuser -p < cleaner.sql

By default this script removes all tickets older than 90 days. The point is in editing the query that collects ticket ids, so if you want any complex criteria - write it here:

    INSERT INTO ticketids(ticketid) 
    SELECT ticketid FROM swtickets WHERE (dateline + (86400 * 90) < UNIX_TIMESTAMP(NOW()));

Run the clean-trash.sql script