OTRS – Delete all tickets from database.
2May 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! 🙂
cyber7 
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;
LikeLike
[…] https://aubreykloppers.wordpress.com/2015/05/29/otrs-delete-all-tickets-from-database/を参考に作業してみましたが、一部エラーが発生し、失敗。 […]
LikeLike