adspace


How is mysql database stored?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1103


Which statement is used in a select query for partial matching?

1247


How to Change a users password from unix shell.

1221


What is current version of mysql?

1081