Re: [Bacula-users] Where is the MediaID increment in MySQL

2007-08-02 Thread Dimitrios
On Wed, 01 Aug 2007 13:42:15 -0500 Jason King <[EMAIL PROTECTED]> wrote: > Does anyone else know where I can find the MediaID increment at? if you are talking about the MySQL auto increment, then this is how you re-set it: ALTER TABLE my_table AUTO_INCREMENT = 1; if you want, you may start fro

Re: [Bacula-users] Where is the MediaID increment in MySQL

2007-08-01 Thread Dan Langille
On 1 Aug 2007 at 13:42, Jason King wrote: > I've had to make some adjustments during my trials of bacula and my > MediaID numbering sequence is way off. My current LAST tape is labeled > "Tape-10" with a MediaID of 10. If I put in a fresh new tape and label > it "Tape-11", the MediaID would pro

[Bacula-users] Where is the MediaID increment in MySQL

2007-08-01 Thread Jason King
I've had to make some adjustments during my trials of bacula and my MediaID numbering sequence is way off. My current LAST tape is labeled "Tape-10" with a MediaID of 10. If I put in a fresh new tape and label it "Tape-11", the MediaID would probably be like 41 or 42 or so because of the deleti