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, 1942🔥, 0💬
Popular Posts:
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...