You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
one table still does not load but no errors.
another table still gives the Clustered index validation error - but dont know why
Thanks for the code, very helpful.
Rob
The text was updated successfully, but these errors were encountered:
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
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:
Thanks for the code, very helpful.
Rob
The text was updated successfully, but these errors were encountered: