What is MIME type "application/x-mysql-table-definition"?

A MIME type is a string that tells browsers and other tools how to handle a particular kind of file.

application/x-mysql-table-definition is a MIME type used for MySQL table structure files. These files store the schema details of a table, such as columns, data types, and indexes, but do not include the actual table data.

They are typically saved with the file extension FRM. The MIME type helps MySQL know how to interpret and rebuild table structures when needed.

Key Uses and Facts:

Schema Storage: Keeps the layout information of a table.
Server Startup: Allows MySQL to load table definitions during startup.
Recovery Operations: Assists in restoring table structures during migration or recovery.
SQL Command Output: Created when a table is defined using SQL commands like CREATE TABLE.

This MIME type is mainly of interest to those managing MySQL databases. It signals that the file content is specific to table definitions. For more details on file types and extensions, visit FileXT.

Associated file extensions

.frm

Usage Examples

HTTP Header

When serving content with this MIME type, set the Content-Type header:


    Content-Type: application/x-mysql-table-definition

HTML

In HTML, you can specify the MIME type in various elements:


    <a href="file.dat" type="application/x-mysql-table-definition">Download file</a>

Server-side (Node.js)

Setting the Content-Type header in Node.js:


    const http = require('http');    
    
    http.createServer((req, res) => {    
      res.setHeader('Content-Type', 'application/x-mysql-table-definition');    
      res.end('Content here');    
    }).listen(3000);

Associated file extensions

.frm

FAQs

What is the application/x-mysql-table-definition MIME type used for?

This MIME type identifies MySQL table definition files, which store the schema structure of a database table. These files typically use the .frm extension and define columns and indexes, but do not contain the actual data rows.

How do I open or view an .frm file?

You cannot view these files with a standard text editor because they contain binary data used internally by the MySQL server. To view the table structure, use the MySQL command line, MySQL Workbench, or utilize the mysqlfrm utility to extract the CREATE TABLE SQL statement.

Should I configure my web server to serve .frm files?

Generally, no. Exposing database structure files to the public is a security risk as it reveals your database schema to potential attackers. If you must serve them for administrative downloads, ensure the directory is password-protected.

Can I recover my database using only the .frm file?

No, the application/x-mysql-table-definition file only contains the structure (schema), not the content. To restore the actual data, you also need the corresponding data files, such as .ibd files for InnoDB or .MYD files for MyISAM engines.

Why does my browser download the .frm file instead of displaying it?

Browsers do not have built-in support for rendering MySQL binary table definitions. When a browser encounters application/x-mysql-table-definition, it defaults to downloading the file so you can open it with a compatible database tool.

What does the 'x-' prefix mean in this MIME type?

The x- prefix indicates that application/x-mysql-table-definition is a non-standard or experimental MIME type. It is not registered with IANA as a global standard but is recognized specifically within the MySQL ecosystem and related tools.

How do I fix a corrupted .frm file?

If an .frm file is corrupted, MySQL may return an error like "Incorrect information in file." You can try running a REPAIR TABLE command if the storage engine supports it, or restore the file from a recent backup.

General FAQ

What is a MIME type?

A MIME (Multipurpose Internet Mail Extensions) type is a standard that indicates the nature and format of a document, file, or assortment of bytes. MIME types are defined and standardized in IETF's RFC 6838.

MIME types are important because they help browsers and servers understand how to process a file. When a browser receives a file from a server, it uses the MIME type to determine how to display or handle the content, whether it's an image to display, a PDF to open in a viewer, or a video to play.

MIME types consist of a type and a subtype, separated by a slash (e.g., text/html, image/jpeg, application/pdf). Some MIME types also include optional parameters.

How do I find the MIME type for a file?

You can check the file extension or use a file identification tool such as file --mime-type on the command line. Many programming languages also provide libraries to detect MIME types.

Why are multiple MIME types listed for one extension?

Different applications and historical conventions may use alternative MIME identifiers for the same kind of file. Showing them all helps ensure compatibility across systems.