[rt-users] reset ticket ID#?

Jesse jesse at fsck.com
Fri Aug 10 14:41:48 EDT 2001


Assuming mysql, if you have removed all tickets from the tickets table, 
mysqldump rt2 >rt2.data
mysqladmin drop rt2
mysqladmin create rt2
mysql rt2 < rt2.data 

should do you.


On Fri, Aug 10, 2001 at 02:28:29PM -0400, Vivek Khera wrote:
> >>>>> "MH" == Martin Hemmings <mhemmings at trakonic.com> writes:
> 
> MH> How do I go about reseting this number so the next ticket entered
> MH> in a clean database starts at #1?
> 
> You need to reset whatever counter your particular database uses.  If
> it is MySQL, you most likely need to recreate the table with the
> autoincrement column.  If it is PostgreSQL, you need to reset the
> sequence value.
> 
> -- 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera Communications, Inc.
> Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

This is scary.  I'm imagining tracerouting you and seeing links like "Route
84" and "Route 9, Exit 14".  Obviously, this is illness induced. 
								--Cana McCoy




More information about the rt-users mailing list