ImmersionULTD ImmersionULTD - 2 years ago 108
MySQL Question

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

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download