Change first isse number

Added by Andre Casteliano over 15 years ago

Hi,

we were using an in-house created bug-tracking software, and now we will use redmine.
I would like to know if it's possible to set the 'start issue number' so we don't start at 1 again. It's our intention to migrate the old 'tickets' of our actual system to redmine, but it can take a few weeks ...

Is there a way for us to change our first issue from '1' to '1500' ?

Thanks in advance,

Andre Casteliano

Replies (1)

RE: Change first isse number - Added by Andre Casteliano over 15 years ago

I'm not used to answer my own questions, but since I found the solution to my 'problem' so quick, maybe I could explain here to help other people on the same situation.

Basically I 'discovered' that redmine use a simple approach to number issues: auto_increment on the id field on the database.
All that is needed to define the 'starting number' for the issues, is to set auto_increment to the desired number.

On console (since we're using linux):

mysql -u<user> -p<password> redmine

Replace <user> and <password> with the correct information to connect to your database.
Now, run this command on the mysql console:

mysql> ALTER TABLE issues SET auto_increment = <number>;
mysql> quit;

Replace <number> with the number you want to use as the 'starting point' for your issues.

And that's it. I hope this instructions can help other redmine users on the same situation.
I've already made some tests and everything is working fine.

Best regards, and sorry for my bad english, it's not my primary language.

Andre Casteliano
Greetings from Brazil.

(1-1/1)

Project

General

Profile

Redmine