Collections:
Data File for MyISAM Storage Engine in MySQL
Where Table Data Is Stored by the MyISAM Storage Engine in MySQL?
✍: 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:
⇒ Backup Tables by Copying MyISAM Files in MySQL
⇐ Tables Using MyISAM Storage Engine in MySQL
2017-09-01, 2288🔥, 0💬
Popular Posts:
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...