Logo

MySQL to Textile Converter

Transform MySQL database dumps into Textile markup format for Redmine, Textpattern, and other Textile-based systems

MySQL Input

Textile Output

About MySQL to Textile Converter

Convert MySQL database dumps (CREATE TABLE and INSERT statements) to Textile markup format for use in Redmine, Textpattern, and other Textile-based content management systems. Textile is a lightweight markup language that provides simple syntax for formatting text and creating tables.

Key Features

  • Header Support: Optional header rows with |_. syntax
  • Cell Alignment: Left (<.), center (=.), or right (>.) alignment
  • Special Character Escaping: Handles pipes and special characters
  • Redmine Compatible: Works with Redmine wiki syntax
  • Textpattern Compatible: Works with Textpattern CMS
  • Smart Parsing: Extracts column names and data from MySQL dumps
  • File Download: Save as .textile file

How to Use

  1. Input MySQL Data: Paste your MySQL CREATE TABLE and INSERT statements or upload a .sql file
  2. Choose Alignment: Select left, center, or right alignment for cells
  3. Configure Header: Toggle header row with |_. syntax
  4. Copy or Download: Use the Copy or Download button to save your Textile markup

Textile Syntax

  • Header Cells: |_. prefix indicates header cells
  • Left Align: <. prefix for left-aligned cells
  • Center Align: =. prefix for center-aligned cells
  • Right Align: >. prefix for right-aligned cells
  • Cell Separator: | character separates cells

Example Conversion

MySQL Input:

CREATE TABLE products (
  id INT,
  name VARCHAR(100),
  price DECIMAL(10,2),
  category VARCHAR(50)
);

INSERT INTO products VALUES (1, 'Laptop', 999.99, 'Electronics');
INSERT INTO products VALUES (2, 'Mouse', 24.99, 'Accessories');

Textile Output (with header, left aligned):

|_<. id |_<. name |_<. price |_<. category |
|<. 1 |<. Laptop |<. 999.99 |<. Electronics |
|<. 2 |<. Mouse |<. 24.99 |<. Accessories |

Textile Output (with header, center aligned):

|_=. id |_=. name |_=. price |_=. category |
|=. 1 |=. Laptop |=. 999.99 |=. Electronics |
|=. 2 |=. Mouse |=. 24.99 |=. Accessories |

Common Use Cases

  • Redmine Wiki: Display database tables in Redmine project wikis
  • Textpattern CMS: Include database data in Textpattern articles
  • Documentation: Create technical documentation with database examples
  • Issue Tracking: Document database schemas in issue descriptions
  • Project Management: Share database information in project documentation

Redmine Integration

The generated Textile markup works seamlessly with Redmine:

  • Wiki Pages: Use in Redmine wiki pages for documentation
  • Issue Descriptions: Include tables in issue descriptions and comments
  • Forums: Post formatted tables in Redmine forums
  • News: Include data tables in project news

Alignment Options

Left Alignment (<.):

  • Default alignment for most content
  • Best for text and mixed content
  • Commonly used for names and descriptions

Center Alignment (=.):

  • Good for headers and short values
  • Creates balanced visual appearance
  • Works well with numeric data

Right Alignment (>.):

  • Best for numeric values and prices
  • Aligns decimal points naturally
  • Professional appearance for financial data

Supported MySQL Syntax

  • CREATE TABLE: Extracts column names for table headers
  • INSERT INTO: Parses data values from INSERT statements
  • Data Types: Handles all MySQL data types (VARCHAR, INT, DECIMAL, etc.)
  • Quoted Strings: Handles single and double quotes with proper escaping

Textile Resources

  • Redmine: Open-source project management (redmine.org)
  • Textpattern: Flexible content management system (textpattern.com)
  • Textile Syntax: Complete markup reference (textile-lang.com)

Privacy & Security

All conversions happen locally in your browser. Your MySQL data is never uploaded to any server, ensuring complete privacy and security.