How is mysql database stored?
Answer / Neeraj Kumar Tyagi
MySQL databases are typically stored on disk, in a series of files. Each table within the database has its own file, and these files are organized in a directory structure. The main file for a MySQL database is named `database_name.frm`, which stores the table definition. The actual data for each table is stored in multiple files with extensions like .MYI (index) and .MYD (data). InnoDB, a storage engine used by MySQL, also uses files named .ibd for each table.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is procedure in mysql?
How can I create database in mysql?
How many columns can be used for creating Index?
How do I backup mysql database on linux?
Is mysql open source?
How do I make an action query?
Can we store pdf files in mysql?
What is the data type for file in mysql?
What are numeric data types?
How do I connect to a mysql database?
What is the limit of mysql database?
What are the limitations of mysql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)