Reset issue ID#
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.
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
Now, run this command on the mysql console:
mysql> ALTER TABLE issues SET auto_increment = <number>;
Replace <number> with the number you want to use as the 'starting point' for
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.