How is mysql database stored?



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

Post New Answer

More MySQL Interview Questions

What is procedure in mysql?

1 Answers  


How can I create database in mysql?

1 Answers  


How many columns can be used for creating Index?

1 Answers  


How do I backup mysql database on linux?

1 Answers  


Is mysql open source?

1 Answers  


How do I make an action query?

1 Answers  


Can we store pdf files in mysql?

1 Answers  


What is the data type for file in mysql?

1 Answers  


What are numeric data types?

1 Answers  


How do I connect to a mysql database?

1 Answers  


What is the limit of mysql database?

1 Answers  


What are the limitations of mysql?

1 Answers  


Categories