Hi everyone, I had lost my database. I had recover the database folder using third-party recovery tool, and it had successfully recovered all the .frm and .idb files. I have no ibdata1 file. How can I recover the database. Please help me
Is there any chance that you have any logical, physical, or binary log backups available?
If you don’t have a base backup, this is probably non-recoverable. The ibdata1 file is critical to the operation of InnoDB. Without it, InnoDB has no knowledge of the tables in your database. Even if you have the .ibd files, they must be imported into InnoDB, but in order to do that, you must have the .cfg files which are created during table export.