Conversion from . FRM to . SQL

Question

I have a 300MB database and all I have are the FRM, MYI and MYD files. I need to convert the FRM files first to create the structure of the tables, I have already used the following tools and methods and have not succeeded:

https://recovery.twindb.com/

Error: ERROR: Failed to correctly read the . frm file. Please Try Reading the file with the --Diagnostic mode.

I tried that way too:

     mysqlfrm --diagnostic "arquivo.frm" > "C:\table.sql"

Message:

WARNING: Cannot generate Character set or collation Names without the --server option. CAUTION: The Diagnostic mode is a best-effort parse of the . frm file. As such, it may not identify all of the Components of the table correctly. This is especially true for Damaged files. It will also not read the default values for the Columns and the Resulting statement may not be syntactically correct. Reading . frm file for client.frm: The . frm file is a TABLE.

And this:

  mysqlfrm –server=root:mypassword@localhost –port=3311 "<source/path>/mytable.frm" > "<destination/path>/recovered_mytable.sql"

Message:

ERROR: process "11892" not found.

Answer 1

Whoa, I got it this way!

Just create some database and create some table too.

Then go into the files that were generated:

C: xampp mysql data DATABASE NAME YOU CREATED

Delete all files from that folder, then paste the files you have: FRM, MYD and MYI, restart the Mysql service, and all done!

ATTENTION:

This method only works if it is the same version (MYSQL), and with the same general parameters. The most appropriate way to transport databases is by generating a DUMP.