Mostly works!

[robcwu]

Hi I tried to recover some tables using the .ibd files. I recovered most of them. I found that some of them did not work. Comparing the table structure to previous, multiple primary keys were not defined in many that gave the 'Clustered index validation error.. By adding all the keys to the sql table structure, this made most of them work. Still have 2 issues:

1. one table still does not load but no errors.
2. another table still gives the Clustered index validation error - but dont know why

Thanks for the code, very helpful. Rob

[anyongjin]

Glad to help you with some questions. Support has been added for the case where the primary key contains multiple columns. If convenient, you can send the ibd file which has not been loaded without error to my email, and I will try to look into it