Deleting all tickets, attachments and users from rt 3.0.4

RT Users
1

Hi,

sorry for this faq - I know it is coming up often, but I need to know once
again how I can clean my database.

The reason I need to do this is because I spent some time installing and
configuring RT3, upgrading to perl 5.8 (surprise - no issues with special
chars anymore!), configuring templates and scripts and am now ready to go
online with it.

During the test-phase some 100 tickets and users have been inserted into rt.
before going live I want to delete all these test-tickets /users and start
with a clean db.

I can’t use initialize db because I don’t want to loose all my settings for
queues, templates and scrips.

So in short, I want to delete everything but
settings/templates/queues/scrips from my database.

Could some friendly soul please pass along the needed sql for 3.0.4?

Thanks a lot.

http://www.StefanSeiz.com
Spamto: bin@imd.net

2

Stefan Seiz talklists@index-s.de writes:

During the test-phase some 100 tickets and users have been inserted into rt.
before going live I want to delete all these test-tickets /users and start
with a clean db.

Could some friendly soul please pass along the needed sql for 3.0.4?

I’m not sure about the sql. there are various reasons trying to remove
tickets like that is a bad idea, check the list archives. But you
should be able to find all the tickets, and delete them all at once
through the RT web interface.

(of course, this leaves them in the db, as deleted, which is the normal RT way.)

seph