Reset issue ID#
Added by Rocky Stephens 6 months ago
Attempting to reset the issue ID# when starting new project. Our current setup continues incrementing from last, but we do need it to restart from 1. Need any help to do this, as I am learning redmine on the fly.
Replies (3)
RE: Reset issue ID#
-
Added by Mischa The Evil 6 months ago
This is something that has been discussed (and rejected) many times before. See #5765 and all its related issues.
RE: Reset issue ID#
-
Added by Rocky Stephens 6 months ago
Yeah, I read thru that before posting. Not asking for the feature to be added, just wanting to know if there is a way to have the DB start from zero. Think this may work...
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.
RE: Reset issue ID#
-
Added by Mischa The Evil 6 months ago
Rocky Stephens wrote:
[...] Think this may work... [...]
I personally wouldn't recommend (re)setting the auto_increment
value manually as this may pose problems lateron. However, if you know what you're doing and you are willing to take the 'risk', YMMV.
(1-3/3)