kayako-cleaner

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

Usage

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

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

Configuration

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()));

Purge all tickets in trash

Run the clean-trash.sql script