• Update data when duplicate keys found on import (add ON DUPLICATE KEY UPDATE)
• Columns separated with:
• Columns enclosed with:
• Columns escaped with:
• Lines terminated with:
• Import these many number of rows (optional):
• Column names: If the data in each row of the file is not in the same order as in the database, list the corresponding column names here. Column names must be separated by commas and not enclosed in quotations.
• Do not abort on INSERT error
• Import empty values as NULL

• Update data when duplicate keys found on import (add ON DUPLICATE KEY UPDATE)
• Columns separated with:
• Columns enclosed with:
• Columns escaped with:
• Lines terminated with:
• Column names:
• Do not abort on INSERT error
• Use LOCAL keyword

• The first line of the file contains the table column names (if this is unchecked, the first line will become part of the data)
• Do not import empty rows
• Import percentages as proper decimals (ex. 12.00% to .12)
• Import currencies (ex. $5.00 to 5.00)

• SQL compatibility mode:NONEANSIDB2MAXDBMYSQL323MYSQL40MSSQLORACLETRADITIONAL
• Do not use AUTO_INCREMENT for zero values
  

• 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

• Output pretty-printed JSON (Use human-readable formatting)
• Output unicode characters unescaped

• 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

Dump table

• structure
  data
  structure and data

Data dump options

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

• 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:

• Report title:

Dump table

• structure
  data
  structure and data

• 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
• Export metadata
• Database system or older MySQL server to maximize output compatibility with:NONEANSIDB2MAXDBMYSQL323MYSQL40MSSQLORACLETRADITIONAL
• structure
  data
  structure and data

Object creation options

• Add statements:
• • Add DROP TABLE / TRIGGER statement
  • Add CREATE TABLE statement
  • • IF NOT EXISTS (less efficient as indexes will be generated during table creation)
    • AUTO_INCREMENT value
  • Add CREATE VIEW statement
  • • Use simple view export
    • Exclude definition of current user
    • OR REPLACE view
  • Add CREATE PROCEDURE / FUNCTION / EVENT statement
  • Add CREATE TRIGGER statement
• 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,col_C) 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:

• Columns separated with:
• Indentation:

• Show color
• Only show keys
• OrientationLandscapePortrait
• Paper sizeA3A4A5letterlegal

• Show color
• Only show keys
• Same width for all tables
• OrientationLandscapePortrait

• Show color
• Only show keys
• Same width for all tables
• OrientationLandscapePortrait
• Paper sizeA3A4A5letterlegal
• Show grid
• Data dictionary
• Order of the tablesNoneName (Ascending)Name (Descending)

• Show color
• Only show keys
• Same width for all tables