Re-initilaize rt database

Hello RT Gurus: We installed RT 3.8.4 and did some testing. We have around
200 test tickets which we would like to completely delete from RT. Is there
any way to do this? Our RT installation is on mysql.

Thank you… rq.

Hello RT Gurus: We installed RT 3.8.4 and did some testing. We have around 200 test tickets
which we would like to completely delete from RT. Is there any way to do this? Our RT
installation is on mysql.

If you want a totally clean database, from your install directory run

make dropdb; make initdb

If you just want to lose the tickets (but want to keep the
users/rights/queues) you want to investigate the rt-shredder tool in
your rt’s sbin dir

-kevin

Will I loose user, rights and queues with initialize database?

I do want to keep all user rights etc. we have make custom scripts and
templates on queues. I do not want to loose them. I only want to delete all
tickets from 1-200 and start from #1 again.
rgds, rtOn Mon, Jul 20, 2009 at 9:30 AM, Kevin Falcone falcone@bestpractical.comwrote:

On Mon, Jul 20, 2009 at 08:26:38AM -0400, testwreq wreq wrote:

Hello RT Gurus: We installed RT 3.8.4 and did some testing. We have
around 200 test tickets
which we would like to completely delete from RT. Is there any way to
do this? Our RT
installation is on mysql.

If you want a totally clean database, from your install directory run

make dropdb; make initdb

If you just want to lose the tickets (but want to keep the
users/rights/queues) you want to investigate the rt-shredder tool in
your rt’s sbin dir

-kevin


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

If you want to delete everything then drop db and init it again. If
you want to delete just tickets then you can shred them.On Mon, Jul 20, 2009 at 4:26 PM, testwreq wreqtestwreq@gmail.com wrote:

Hello RT Gurus: We installed RT 3.8.4 and did some testing. We have around
200 test tickets which we would like to completely delete from RT. Is there
any way to do this? Our RT installation is on mysql.

Thank you… rq.


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

Yes, read the answer you replied to:

If you just want to lose the tickets (but want to keep the
users/rights/queues) you want to investigate the rt-shredder tool in
your rt’s sbin dir

Richard Foley
Ciao - shorter than aufwiedersehen

One, Two, Free! – Richard Foley Monday 20 July 2009 15:36:09 testwreq wreq wrote:

Will I loose user, rights and queues with initialize database?

I do want to keep all user rights etc. we have make custom scripts and
templates on queues. I do not want to loose them. I only want to delete all
tickets from 1-200 and start from #1 again.
rgds, rt
On Mon, Jul 20, 2009 at 9:30 AM, Kevin Falcone falcone@bestpractical.comwrote:

On Mon, Jul 20, 2009 at 08:26:38AM -0400, testwreq wreq wrote:

Hello RT Gurus: We installed RT 3.8.4 and did some testing. We have
around 200 test tickets
which we would like to completely delete from RT. Is there any way to
do this? Our RT
installation is on mysql.

If you want a totally clean database, from your install directory run

make dropdb; make initdb

If you just want to lose the tickets (but want to keep the
users/rights/queues) you want to investigate the rt-shredder tool in
your rt’s sbin dir

-kevin


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com