MySQL - Revision history

Thorsted: /* Other links */

2023-08-18T16:50:26Z

‎Other links

Thorsted: /* File format information */

2023-06-14T00:14:31Z

‎File format information

Jsummers: PRONOM update

2018-10-08T22:45:49Z

PRONOM update

Jsummers: PRONOM

2016-04-24T12:06:10Z

PRONOM

Dan Tobias: /* Other links */

2015-01-10T22:13:38Z

‎Other links

Dan Tobias: /* Other links */

2015-01-10T22:09:49Z

‎Other links

Dan Tobias at 12:37, 25 June 2014

2014-06-25T12:37:45Z

Jsummers at 00:17, 23 April 2014

2014-04-23T00:17:59Z

Dan Tobias: 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..."

2014-04-22T03:52:39Z

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..."

New page

{{FormatInfo
| formattype=electronic
| subcat=Databases
| extensions={{ext|frm}}, {{ext|myd}}, {{ext|myi}}
}}
:''MySQL: the Comic Sans of databases. Except Comic Sans has uses.''
:-- [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.

== File format information ==
* [http://dev.mysql.com/doc/internals/en/frm-file-format.html .frm files]
* [http://dev.mysql.com/doc/internals/en/myisam-record-structure.html .myd and .myi files]

== Other links ==
* [[Wikipedia:MySQL|Wikipedia article]]
* [http://www.mysql.com/ Official site]

← Older revision		Revision as of 16:50, 18 August 2023
Line 23:		Line 23:
	* [http://reddragdiva.dreamwidth.org/593924.html Why MySQL is not my favourite database.]		* [http://reddragdiva.dreamwidth.org/593924.html Why MySQL is not my favourite database.]
	* [http://grimoire.ca/mysql/choose-something-else Do Not Pass This Way Again]		* [http://grimoire.ca/mysql/choose-something-else Do Not Pass This Way Again]
		+	* [https://bits.ashleyblewer.com/blog/2023/08/11/researching-file-formats-2-mysql-table-definition-format/ MySQL Table Definition Format Blog post]

@@ Line 3: / Line 3: @@
 | subcat=Databases
 | extensions={{ext|frm}}, {{ext|myd}}, {{ext|myi}}, {{ext|ibd}}
-| pronom={{PRONOM|fmt/868}}
+| pronom={{PRONOM|fmt/868}}, {{PRONOM|fmt/1197}}
 }}
 :''MySQL: the Comic Sans of databases. Except Comic Sans has uses.''

← Older revision		Revision as of 22:13, 10 January 2015
Line 21:		Line 21:
	* [http://www.mysql.com/ Official site]		* [http://www.mysql.com/ Official site]
	* [http://reddragdiva.dreamwidth.org/593924.html Why MySQL is not my favourite database.]		* [http://reddragdiva.dreamwidth.org/593924.html Why MySQL is not my favourite database.]
		+	* [http://grimoire.ca/mysql/choose-something-else Do Not Pass This Way Again]

← Older revision		Revision as of 22:09, 10 January 2015
Line 20:		Line 20:
	* [[Wikipedia:MySQL\|Wikipedia article]]		* [[Wikipedia:MySQL\|Wikipedia article]]
	* [http://www.mysql.com/ Official site]		* [http://www.mysql.com/ Official site]
		+	* [http://reddragdiva.dreamwidth.org/593924.html Why MySQL is not my favourite database.]

← Older revision		Revision as of 12:37, 25 June 2014
Line 8:		Line 8:

	'''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.		'''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.
		+
		+	== UTF-8 in MySQL ==
		+
		+	To use the proper [[UTF-8]] standard for character encoding, you need to designate the character set parameter as [https://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html utf8mb4], because the more appropriate 'utf8' was already used to designate a subset of this standard which encompasses only the BMP characters (in the range U+0000 to U+FFFF), not the supplementary characters at higher code points, which take four bytes to express in UTF-8.

	== File format information ==		== File format information ==

@@ Line 15: / Line 15: @@
 == File format information ==
-* [http://dev.mysql.com/doc/internals/en/frm-file-format.html .frm files]
+* [https://web.archive.org/web/20131210155407/http://dev.mysql.com/doc/internals/en/frm-file-format.html .frm files (archived)]
-* [http://dev.mysql.com/doc/internals/en/myisam-record-structure.html .myd and .myi files]
+* [https://web.archive.org/web/20131210151954/http://dev.mysql.com/doc/internals/en/myisam-record-structure.html .myd and .myi files (archived)]
 == Other links ==