Aly Ahmed Mohamed Aly Ahmed Mohamed - 1 year ago 65
MySQL Question

What are the generated files when creating a table in MySQL (.opt, .frm, .MYD, .MYI)

When I create a database in MySQL and create a table called

in it, 4 files are generated:

  1. db.opt

  2. flats.frm

  3. flats.MYD

  4. flats.MYI

This happens every time a table is created.

What are these files?

pah pah
Answer Source

The file db.opt contains the database characteristics. It is updated every time the database is altered.

For the remaining 3 files:

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