localhost
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize
View dump (schema) of databases
Export
Select All
/
Unselect All
3rs
CodeGen
CSV
CSV for MS Excel
Microsoft Word 2000
LaTeX
MediaWiki Table
Open Document Spreadsheet
Open Document Text
PDF
PHP array
SQL
Texy! text
Excel 97-2003 XLS Workbook
Excel 2007 XLSX Workbook
YAML
Options
Format
NHibernate C# DO
NHibernate XML
Options
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Replace NULL by
Remove CRLF characters within fields
Put fields names in the first row
Options
Replace NULL by
Remove CRLF characters within fields
Put fields names in the first row
Excel edition
Windows
Excel 2003 / Macintosh
Excel 2008 / Macintosh
Options
Structure
Data
Replace NULL by
Put fields names in the first row
Options
Include table caption
Structure
Table caption
Continued table caption
Label key
Comments
Data
Put fields names in the first row
Table caption
Continued table caption
Label key
Replace NULL by
Options
This format has no options
Options
Replace NULL by
Put fields names in the first row
Options
Structure
Comments
Data
Put fields names in the first row
Replace NULL by
Options
(Generates a report containing the data of a single table)
Report title
Options
This format has no options
Options
Add custom comment into header (\n splits lines)
Comments
Enclose export in a transaction
Disable foreign key checks
SQL compatibility mode
NONE
ANSI
DB2
MAXDB
MYSQL323
MYSQL40
MSSQL
ORACLE
TRADITIONAL
Database export options
Add DROP DATABASE
Structure
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add CREATE PROCEDURE / FUNCTION / EVENT
Add into comments
Creation/Update/Check dates
Data
Complete inserts
Extended inserts
Maximal length of created query
Use delayed inserts
Use ignore inserts
Use hexadecimal for BLOB
Export type
INSERT
UPDATE
REPLACE
Options
Structure
Data
Replace NULL by
Put fields names in the first row
Options
Replace NULL by
Put fields names in the first row
Options
Replace NULL by
Put fields names in the first row
Options
This format has no options
Save as file
File name template
1
:
(
remember template
)
Compression:
None
"zipped"
"gzipped"
"bzipped"
1
This value is interpreted using
strftime
, so you can use time formatting strings. Additionally the following transformations will happen: __SERVER__/ server name. Other text will be kept as is.