-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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?
Thanks.
Mike
Mike Friedman System and Network Security
mikef@ack.Berkeley.EDU 2484 Shattuck Avenue
1-510-642-1410 University of California at Berkeley
http://ack.Berkeley.EDU/~mikef http://security.berkeley.edu
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQA/AwUBQymdO60bf1iNr4mCEQIAHgCggse1KcIIHotS8CbBlkXzZerLXWcAoKbj
KeOkFTSidYkIKg8Kn+6FvneQ
=83Jv
-----END PGP SIGNATURE-----