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, 1969🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...