According to the MySQL manual, the auto_increment can be forced to a number by using "myisamchk --set-auto-increment=1 /path-to/table.MYI".
I've tried to reset the number to 1, and linux also responsed the message "Updating MyISAM file: /path-to/table.MYI".
It looks like successful, but while I select the index from the table, the Auto_increment still keep at the same old number.
Is there somebody reset the index successfully? or how to do that? since drop then add index again won't work.
Thanks.
I've tried to reset the number to 1, and linux also responsed the message "Updating MyISAM file: /path-to/table.MYI".
It looks like successful, but while I select the index from the table, the Auto_increment still keep at the same old number.
Is there somebody reset the index successfully? or how to do that? since drop then add index again won't work.
Thanks.