[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