Im using
myisamchk -A=200 invoices.MYI
to change the auto_increment ID to a higher number, but Im not getting any love.
I have found other threads with people having the same problem, but never a "valid" solution. Most people need to reset the ID to the start, so are told to dump and reload the table.
That doesnt work for my need, so please dont sugest it...
