Corrupted auto_increment?

[Jim McAtee]

A server running MySQL 3.23 crashed yesterday.  Since bringing it back 
online, doing inserts into a particular table will throw an error 
regarding a duplicate key value in an auto_increment field.  I assume that 
something is corrupted.

There are 779239 records, the most recently added having an auto_increment 
ID field of 779239.  When a new record is added, MySQL attempts to give it 
an ID of 779240, but then throws the error that this ID is a duplicate.

How to fix? 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]