search

anyongjin / mysql_ibd

import data from ibd files for mysql
MIT License
30 stars 5 forks source link

Mostly works! #2

Open robcwu opened 2 years ago

robcwu commented 2 years ago

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 commented 2 years ago

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