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, 2555🔥, 0💬
Popular Posts:
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...