Re: Database File location
A database is a directory.
In that directory are 1-3 files per table.
A MyISAM table has a .frm (schema), a .MYD (data), and a .MYI (index(es)). A MyISAM table is completely embodied in those 3 files.
An InnoDB table has a .frm (schema) and _may_ have a .ibd with the data and indexes -- if innodb_file_per_table = ON.
An InnoDB table is not entirely in the files; the file ibdata1 (no extension) is vital, too. "Transportable tablespaces" will soon be the workaround for that.
Those files are not useful other than in mysql's tree.
Subject
Written By
Posted
Re: Database File location
July 08, 2015 07:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.