Logo

MySQL to Textile Converter

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

MySQL Input

Convert MySQL to other formats

MySQL to ActionScriptMySQL to ASCIIMySQL to AsciiDocMySQL to ASPMySQL to AvroMySQL to BBCodeMySQL to CSVMySQL to DAX

Textile Output

Convert other formats to Textile

CSV to TextileExcel to TextileHTML to TextileJSON to TextileLaTeX to TextileMarkdown to TextileMediaWiki to TextileSQL to Textile

Related Tools

MySQL to TOML

Convert MySQL CREATE TABLE and INSERT statements to TOML configuration file format

MySQL to TracWiki

Convert MySQL CREATE TABLE and INSERT statements to TracWiki table markup format for Trac project management

MySQL to XML

Convert MySQL CREATE TABLE and INSERT statements to XML format with customizable structure and formatting

MySQL to YAML

Convert MySQL CREATE TABLE and INSERT statements to YAML format for configuration and data serialization

SQL to ActionScript

Convert SQL CREATE TABLE and INSERT statements to ActionScript arrays, vectors, and objects for Flash/AIR

SQL to ASCII

Convert SQL database dumps to ASCII table format with borders and alignment

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.

FAQ

  • Which parts of my SQL are required? Ideally include both CREATE TABLE and INSERT statements. If only INSERT statements are present, the tool will infer or generate column names.
  • Why do pipes (|) look escaped? Textile uses | as a cell separator, so the converter escapes literal pipes inside cell content to avoid breaking the table structure.
  • Can I mix Textile tables with other markup? Yes. You can paste the generated table into any Textile-supported area (Redmine wiki, Textpattern article, etc.) alongside headings, lists, and other content.
  • Which alignment should I choose? Left alignment is best for text, right for numeric values like prices, and center for short labels or headers. You can experiment and preview in your Textile renderer.
  • Does the tool change my data? Only minimal formatting is applied (escaping special characters and flattening newlines) so that values render safely inside Textile tables.