How to restore the table using .IBD files

Hi there
i have only the .ibd files of some tables,would it be possible to restore the tables …?

If you are using MySQL 8, you can put the .ibd files back into their original location and restart MySQL. InnoDB will scan for all .ibd files and update the internal dictionary.

1 Like