Search code examples
mysqlmysql-workbenchfrm

Where are my .myd, .myi and .frm files from my mysql database

I'm a beginner here and I can't seem to find the files. My professor wants me to send these files specifically to her, but when I "export data" from the workbench, it only generates .sql files. Where do I get the .myd, .myi and .frm files she's looking for.

Thank you

Solution

  • Somewhere there is a data directory under a directory with MySQL in the filename, and under data is your own database directory. Files are in there. But if you haven't used MyISAM as the table format, the files will have different extensions, e.g. .idb for InnoDB.

    You can find it via the query mentioned in @tadman's comment, or from a shell:

    find / -name data -print

    although you will probably get a number of matches.

    You will have to stop the MySQL server before you can copy the files.