MySQL auto-increment value

swissmissflash

Hello,

I just recently had to move my phpBB database over to a new server (which wen't fine, it's up and running) but when it inserts a new row into the users database the auto increment value jumped from 6266 to 8388607!! Now I know I should be able to change that via:

ALTER TABLE `phpbb_users`  AUTO_INCREMENT ='6267'

but when i do that the value stays the same. I have tried changing in using phpMyAdmin as well with the same results... :mad:

Any suggestions for me? Normally I wouldn't care but it keeps saying 'duplicate entry key' when I try to insert a new one as well. I have checked the structure for the column and it is set to auto-increment.

Thanks you for your time. I honestly appriciate any input.

Shrike

When you create the table you can specify where the auto incrementing value should start - might be worth a shot.

swissmissflash

Shrike wrote:
When you create the table you can specify where the auto incrementing value should start - might be worth a shot.

Hi,

Just tried that and it does work but as soon as i enter some of the data... even 1 entry the value jumps to 8388607 i have no idea where that number is coming from either cuz none of the entries are anywhere near that amount.

Anyone else have any ideas for me?