OTRS – Delete all tickets from database.

1

May 29, 2015 by aubreykloppers

I am running a test site and would like to implement/clear the tickets to start fresh.  To Delete (flush) database of tickets and start fresh:

#mysql -uroot -p

sql>use otrs2;
sql> delete from ticket_history;
sql> delete from article;
sql> delete from article_attachment;
sql> delete from article_plain;
sql> delete from time_accounting;
sql> delete from ticket;

That’s it – no more tickets!

ps – To my sister: Flush it babes! 🙂

Advertisements

One thought on “OTRS – Delete all tickets from database.

  1. Sherin Shahanas says:

    Please find updated commands. It worked for me.

    #mysql -u -p

    delete from ticket_history;
    delete from article_attachment;
    delete from article_flag;
    delete from article_plain;
    delete from article;
    delete from time_accounting;
    delete from ticket_history;
    delete from ticket_flag;
    delete from ticket;

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: