Mysql table Schema Recovery from .frm file using mysql utilities

Mysql table Schema Recovery from .frm file using mysql utilities

Mysql Utilties Download link

https://downloads.mysql.com/archives/utilities/

-> Run Mysql utility console

Syntax:

mysqlfrm --diagnostic <Path>/XXX.frm

mysqlfrm --diagnostic C:/transactiontable.frm

or cmd window

mysqlfrm --server=root@192.168.1.235:3306 c:/Accountyears.frm > c:/c.txt --diagnostic --port=3306 -vvv --user=root

mysqlfrm --server=root:Pwd@192.168.1.235:3306 c:/Accountyears.frm > c:/c.txt --diagnostic

screen shot:

Result: