MySQL

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(Created page with "{{FormatInfo | formattype=electronic | subcat=Databases | extensions={{ext|frm}}, {{ext|myd}}, {{ext|myi}} }} :''MySQL: the Comic Sans of databases. Except Comic Sans has uses...")
 
Line 2: Line 2:
 
| formattype=electronic
 
| formattype=electronic
 
| subcat=Databases
 
| subcat=Databases
| extensions={{ext|frm}}, {{ext|myd}}, {{ext|myi}}
+
| extensions={{ext|frm}}, {{ext|myd}}, {{ext|myi}}, {{ext|ibd}}
 
}}
 
}}
 
:''MySQL: the Comic Sans of databases. Except Comic Sans has uses.''
 
:''MySQL: the Comic Sans of databases. Except Comic Sans has uses.''
 
:-- [https://twitter.com/davidgerard/status/382443964608954368 David Gerard]
 
:-- [https://twitter.com/davidgerard/status/382443964608954368 David Gerard]
  
'''MySQL''' is a popular open-source database system using the [[SQL]] query language. Its files are stored with the field definitions in '''.frm''' files, the data in '''.myd''' files, and indexes in '''.myi''' files.
+
'''MySQL''' is a popular open-source database system using the [[SQL]] query language. Its files are traditionally stored with the field definitions in '''.frm''' files, the data in '''.myd''' files, and indexes in '''.myi''' files. The newer ''InnoDB'' storage engine replaces the .myd and .myi files with a shared "ibdata1" file, and in most cases an '''.ibd''' file for each database.
  
 
== File format information ==
 
== File format information ==

Revision as of 00:17, 23 April 2014

File Format
Name MySQL
Ontology
Extension(s) .frm, .myd, .myi, .ibd
MySQL: the Comic Sans of databases. Except Comic Sans has uses.
-- David Gerard

MySQL is a popular open-source database system using the SQL query language. Its files are traditionally stored with the field definitions in .frm files, the data in .myd files, and indexes in .myi files. The newer InnoDB storage engine replaces the .myd and .myi files with a shared "ibdata1" file, and in most cases an .ibd file for each database.

File format information

Other links

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox