What is MIME type "application/x-mysql-db"?

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

application/x-mysql-db is a MIME type that identifies files storing MySQL table definitions. These files hold the structure of a database table, such as field types, indexes, and other metadata. They do not contain actual table data.

Files using this MIME type follow the MySQL Table Definition Format found in the file FRM.

Key facts and use cases:

• Database Schema Storage: It marks files that contain table structure details used by MySQL.
• System Integration: Software tools and database utilities use it to recognize and process table definitions.
• Backup and Migration: The format can be involved in backing up and transferring database schemata.

This MIME type, with its "x-" prefix, signals a non-standard use case tailored to MySQL environments. For more detailed information about the file format, explore external resources such as this reference.

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-db
  

HTML

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

    <a href="file.dat" type="application/x-mysql-db">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-db');
      res.end('Content here');
    }).listen(3000);
  

Associated file extensions

.frm