-----BEGIN PGP SIGNED MESSAGE-----
Checking the archives of this list, I see advice on setting the initial
ticket number for a new RT database. This is for mysql 4.1.13. The advice
is to use the following command:
ALTER TABLES Tickets auto_increment=nnnn
to cause ticket numbers to begin with nnnn + 1.
However, the mysql manual says, “The effect of this option is canceled by
a server restart”. I verified that this is the case by restarting my
mysql server after setting auto_increment for the Tickets table to 60000.
The value did get set to 60000, as shown by a SHOW TABLE STATUS (BTW, is
there a better way to display just the value of auto_increment?).
However, after restarting the mysql server, the value of auto_increment
went back to 1.
So, what do I do if I want to retain the value of 60000 even if my server
happens to restart (say because of a reboot)? Once I start creating
tickets in my new RT database (starting at 60001, I hope), I wouldn’t want
new ticket numbers suddenly to be assigned lower values just because the
server happened to restart at some point in the future.
Could someone clarify all this?
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
-----END PGP SIGNATURE-----