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, 2068🔥, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...