Mysql Auto generate duplicate id after restart the server(deleted primary key)

[shivaa raaj]

Hi,
Mysql - INNODB engine.

My problem is after delete primary key record(Auto Increment) the mysql behaviour is it will not generate same id again. Because, the auto increment from mysql server session. But, after restart mysql server it is generating duplicate id for particular table. The reason is mysql session is destroyed once restart the server.

Soln :Mysql server itself keep some where the max increment id in my sql server.
Or the duplicate primary key should not generate(after restart the mysql server). Is it possible...?


Thanks. looking forward your reply