Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Where Table Data Is Stored by the MyISAM Storage Engine
Where Table Data Is Stored by the MyISAM Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: FYIcenter.com
By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, each database will have its own subdirectory to store table data.
If a new table is created with the MyISAM storage engine, several files will be created. For example, the new table "fyi_isam" created in the previous tutorial exercise will result the following files:
>cd \mysql\data\fyi >dir 8,620 fyi_isam.frm 0 fyi_isam.MYD 1,024 fyi_isam.MYI ...
These files are:
2007-05-10, 4761👍, 0💬
Popular Posts:
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL If you want create an ar...
What Is the "@SuiteClasses" Annotation? "@SuiteClasses" is a class annotation defined in JUnit 4.4 i...
What is the benefit of using an enum rather than a #define constant? The use of an enumeration const...
What is CMM and different levels? explain? The Capability Maturity Model (CMM) is a process capabili...
Can Two Forms Be Nested? - XHTML 1.0 Tutorials - Understanding Forms and Input Fields Can two forms ...