OTRS – Delete all tickets from database.

Leave a comment

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

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: