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, 1495🔥, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...