1. Kayako Download customers: we will continue to develop and support Kayako Download beyond July 2017, alongside the new Kayako for existing customers.

    Find out more.

  2. The forum you are viewing relates to Kayako Classic. If you signed up or upgraded to the new Kayako (after the 4th July 2016), the information in this thread may not apply to you. You can visit the forums for the new Kayako here.

Delete all tickets?

Discussion in 'Using Kayako Classic' started by Armin.Horst, Jul 20, 2012.

  1. Armin.Horst

    Armin.Horst Established Member

    is there a way/script to delete all tickets?

    to test the update from V3 to V4 I have imported my V3-database, changed some settings and templates, ...
    Now I would like colleagues to test their standard operations in the StaffCP (in my test system), but of course I would like to avoid that any of their actions accidently triggers emails to our customers.
    I already did change the domain for the queues, to avoid to import emails from production.

    I could go to mysql and delete all rows from swtickets, but I guess there are more tables involved (swticketposts, swticketemails, ...)

    Armin Horst
  2. Gary McGrath

    Gary McGrath Staff Member

    Hi there Armin,

    I would recommend you simply create a new blank mysql database and use that, then you know 100% that your staff wont accidentally send stuff to your live customers.

  3. Armin.Horst

    Armin.Horst Established Member



    creating a new database forces me to all configurations again and many of them can only be done manually in the AdminCP (?). As far as I can see there is only an export/import process for templates, for things like staff, departments, ticket status, queues, ... I either import them from V3 or do them all manually starting with the Resolve defaults

    At the end, being able to keep/transport the AdminCP-Settings without any tickets is what I'm looking for

    thanks for your help
  4. cginest

    cginest Established Member

    Any luck with the right SQL statements to delete existing tickets? I'd like to get rid of mine but keep config for a dev instance. Thanks!
  5. Drew Keller

    Drew Keller Just one person in a world of millions.

  6. Gary McGrath

    Gary McGrath Staff Member

    Hi there,

    As Drew posted, you can use the script I wrote in that thread, it will clear out all tickets ( if you use an appropriate date )

    Just an FYI also, it also clears all ticket tables, including audit logs etc.. :)


Share This Page