• Format:NHibernate C# DONHibernate XML

• Columns separated with:
• Columns enclosed with:
• Columns escaped with:
• Lines terminated with:
• Replace NULL with:
• Remove carriage return/line feed characters within columns
• Put columns names in the first row

• Replace NULL with:
• Remove carriage return/line feed characters within columns
• Put columns names in the first row
• Excel edition:WindowsExcel 2003 / MacintoshExcel 2008 / Macintosh

Dump table

• structure
• data
• structure and data

Data dump options

• Replace NULL with:
• Put columns names in the first row

• Include table caption

Dump table

• structure
• data
• structure and data

Object creation options

• Table caption:
• Table caption (continued):
• Label key:
• Display comments

Data dump options

• Put columns names in the first row:
• Table caption:
• Table caption (continued):
• Label key:
• Replace NULL with:

Dump table

• structure
• data
• structure and data
• Export table names
• Export table headers

• Replace NULL with:
• Put columns names in the first row

Dump table

• structure
• data
• structure and data

Object creation options

• Display comments

Data dump options

• Put columns names in the first row
• Replace NULL with:

• (Generates a report containing the data of a single table)

• Report title:

• Display comments (includes info such as export timestamp, PHP version, and server version)
• • Additional custom header comment (\n splits lines):
  • Include a timestamp of when databases were created, last updated, and last checked
• Enclose export in a transaction
• Disable foreign key checks
• Export views as tables
• Database system or older MySQL server to maximize output compatibility with:NONEANSIDB2MAXDBMYSQL323MYSQL40MSSQLORACLETRADITIONAL
• Add DROP DATABASE statement
• structure
• data
• structure and data

Object creation options

• Add statements:

• • Add CREATE DATABASE / USE statement
  • Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement
  • Add CREATE PROCEDURE / FUNCTION / EVENT statement
  • CREATE TABLE options:
  • • IF NOT EXISTS
    • AUTO_INCREMENT
• Enclose table and column names with backquotes (Protects column and table names formed with special characters or keywords)

Data creation options

• Truncate table before insert

• Instead of INSERT statements, use:

• • INSERT DELAYED statements
  • INSERT IGNORE statements
• Function to use when dumping data:INSERTUPDATEREPLACE

• Syntax to use when inserting data:

• • include column names in every INSERT statement
          Example: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3)
  • insert multiple rows in every INSERT statement
          Example: INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)
  • both of the above
          Example: INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)
  • neither of the above
          Example: INSERT INTO tbl_name VALUES (1,2,3)
• Maximal length of created query
• Dump binary columns in hexadecimal notation (for example, "abc" becomes 0x616263)
• Dump TIMESTAMP columns in UTC (enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones)

Dump table

• structure
• data
• structure and data

Data dump options

• Put columns names in the first row
• Replace NULL with: