[rt-users] resetting ticket numbers

[Walmach, Joe]

In addition to the other replies on this subject I'm going to include an
answer to my original question which I just implemented.

 

On my Linux sever running mysql I did the following:

 

After backing up the data base I logged into mysql and switched to my rt
database.

 

I then ran:

 

TRUNCATE TABLE Tickets ;

 

And then 

 

TRUNCATE TABLE Transactions ;

 

I then restarted mysql

 

This emptied the Tickets table and all historical data on those same
tickets that resided in the Transactions table. I now am back to ticket
number 1 without the history of the previous tickets showing up. In
addition I didn't have to disrupt my queues, users, scrips, etc.  I hope
this is of value to someone.

 

Joe

 

 

 

________________________________

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Walmach,
Joe
Sent: Friday, November 18, 2005 9:35 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] resetting ticket numbers

 

Is it possible to reset the tickets back to zero? We're finished with
our testing and want to go live but it would be good to erase all the
test tickets first. Deleting them still holds them in the data base with
the counter leaving off with the last ticket number. Truncating the
ticket table in mysql (Linux) brought me back to zero but all new
tickets include the original data in the history view. For example,
ticket number 1 shows what transpired in the original ticket #1. I hope
I'm not asking a question that's already been answered. I've searched
the archives and only found one incident of this question which went
unanswered. Any help would be appreciated.

 

Thanks,

 

Joe

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20051118/c17136e6/attachment.htm>