Search code examples
mysqlsqltoadrecovery

.mdf equivalent for mysql (TOAD)

What is 'SQL Server Database Primary Data File (.mdf)' equivalent for mysql.

  • I am using 'Toad for mysql' (Vesion 7.7) tool
Solution

  • Assuming that you are using MyISAM engine it should be *.myd extension file which corresponds to data file and *.frm corresponds to table format file.

    Per MySQL Documentation

    Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). The file bears the same name as the table, with an .frm extension. The .frm format is the same on all platforms, but in the description of the .frm format that follows, the examples come from tables created under the Linux operating system.