Reset issue ID#

Added by Rocky Stephens 11 days 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 11 days 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 11 days 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 10 days 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)