Page 1 of 1

Reset Issue ID?

Posted: 20 Jun 2014, 17:21
by ChrisOFNA
Hey Guys,

I'm running MantisBT 1.2.17 and I was wondering if there was anyway to reset the Issue IDs back to 0? I deleted all the issues I had after testing out but now we will be implementing this in the field and we want to start fresh.

Re: Reset Issue ID?

Posted: 20 Jun 2014, 18:36
by atrol
Running the following statement in your database should work

Code: Select all

ALTER TABLE mantis_bug_table AUTO_INCREMENT=1;

Re: Reset Issue ID?

Posted: 20 Jun 2014, 18:42
by ChrisOFNA
Sorry for my ignorance but where would I run this at? I set this up on a Windows 2008 R2 machine.

Re: Reset Issue ID?

Posted: 20 Jun 2014, 18:53
by atrol
I don't know what you have installed on your machine.
You can run this with any MySQL database client, e.g. phpMyAdmin, mysql command line, MySql Workbench, ...

Re: Reset Issue ID?

Posted: 20 Jun 2014, 19:14
by ChrisOFNA
phpMyadmin, definitely not MySQL.