Is it possible to restore databases with frm files?

Question

MySQL

I have three folders that were on the path /var/lib/mysql. Each folder contains files of the form table_name.frm and db.opt . I want to restore the databases now, but by simply dropping these folders to where they were before, only the databases themselves were restored, and inside they are empty, there are no tables, although they should be there. Is it possible to restore databases completely with table structures having these folders?

Answer 1

Yes, you can restore the structure, but you need to parse these files - here is a description of their structure: dev.mysql.com/doc/internals/en/frm-file-format.html
Create code from them that creates the necessary tables, and in a fresh database it execute.

Answer 2

No, the structure of the table itself is described in the .frm file, the data itself is stored in the ibdata file, if it was deleted or damaged, then goodbye data.

Answer 3

You can restore as described here: www.msav.ru/blog/276-restore-a-mysql-database-from...