0

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

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

closed as off-topic by mustaccio, Shanky, Andriy M, Max Vernon, LowlyDBA Aug 26 '16 at 18:22

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – mustaccio, Shanky, Andriy M, Max Vernon, LowlyDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

1

MYSQL usually comes with MyISAM/INNODB databases.

For MyISAM the files are:

.MYD for data files
.MYI for index files
.frm for table format files

InnoDB uses a single container file for the data and .frm for the definition and .ibd for the indexes.

Are you trying to load data from SQL Server .MDF into MySQL DB? In simple words are you tring to migrate from SQL server to MYSql?

Regards.

  • Thanks for quick response. Actualy my hard disk is crashed but still able to find .frm,myi and .myd files in C drive but I am not able to find procedures. – Munavvar Aug 26 '16 at 10:06
  • 1
    That is not try for InnoDB. InnoDB uses a single container file for the data and .frm for the definition and .ibd for the indexes. – a_horse_with_no_name Aug 26 '16 at 10:07
  • Thank you for the information @a_horse_with_no_name. I will update my answer accordingly. – Bibhuti Bhusan Padhi Aug 26 '16 at 10:10

Not the answer you're looking for? Browse other questions tagged or ask your own question.