phpMyAdmin setup

Customize export options

Database export options
Comments
Creation/Update/Check dates
Relations
MIME type
Enclose export in a transaction
Disable foreign key checks
SQL compatibility mode
Add DROP DATABASE
Dump table
Structure
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT
Add CREATE PROCEDURE / FUNCTION / EVENT
`CREATE TABLE` options:
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and column names with backquotes
Data
Use delayed inserts
Use ignore inserts
Export type
Syntax to use when inserting data
Maximal length of created query
Use hexadecimal for BLOB
Export time in UTC

Format

CSV
Columns terminated by
Columns enclosed by
Columns escaped by
Lines terminated by
Replace NULL by
Remove CRLF characters within columns
Put columns names in the first row
CSV for MS Excel
Replace NULL by
Remove CRLF characters within columns
Put columns names in the first row
Excel edition

Structure
Include table caption
Dump table
Table caption
Continued table caption
Label key
Relations
Comments
MIME type
Data
Put columns names in the first row
Table caption
Continued table caption
Label key
Replace NULL by

Microsoft Word 2000
Dump table
Replace NULL by
Put columns names in the first row

Open Document Spreadsheet
Put columns names in the first row
Replace NULL by
Open Document Text
Dump table
Structure
Relations
Comments
MIME type
Data
Put columns names in the first row
Replace NULL by

Data
Dump table
Replace NULL by
Put columns names in the first row