Tablespace import issue with auto_increment columns - MySQL Bug

I can export and import tables using tablespace. However I am running into MySQL bug as reported here.

import table which contain auto_increment column, then restart the DB server, insert the new row, it will report error : ERROR 1062 (23000): Duplicate entry ‘1’ for key ‘t2.PRIMARY’ the mysql-test script as follow.

Is there a workaround to this problem? Any MySQL command to force the MySQL to adhere to appropriate auto increment values?

This bug has been marked as normal for the MySQL side so I don’t know when it will get fixed.

1 Like

I have figured out the solution and it is working. I have posted it on the original ticket itself. I am posting it here for the reference again.

The idea is to reset the AUTO_INCREMENT after the import.


1 Like