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.