Collections:
Data File of BDB Storage Engine in MySQL
Where Table Data Is Stored by the BDB 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, the BDB storage engine will create one file for each table to store table data and index data.
If a new table is created with the BDB storage engine, one format file named as databaseName\tableName.frm will be created. Another file named as databaseName\tableName.db to store table data and index data. For example, the new table "fyi_bdb" created in the previous tutorial exercise will result the following files:
>cd \mysql\data >dir fyi\fyi_bdb.* 49,152 fyi_bdb.db 8,620 fyi_bdb.frm
⇒ Tables Using CSV Storage Engine in MySQL
⇐ Starting mysqld to Support BDB Storage Engine in MySQL
2017-08-13, 1503🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...