phpMyAdmin setup

Export

Export defaults
SQL
CodeGen
CSV
LaTeX
Microsoft Office
OpenDocument
Texy! text

Export defaults

Customize default export options.

Quick
Export method
Save on server
Overwrite existing file(s)
Custom
Format
Compression
Character set of the file
Use `LOCK TABLES` statement
Export as separate files
Save as file
Save on server
Overwrite existing file(s)
Table name template
Database name template
Server name template

SQL

Customize default options.

Structure
Comments
Creation/Update/Check dates
Relationships
MIME type
Enclose export in a transaction
Disable foreign key checks
Export views as tables
Export related metadata from phpMyAdmin configuration storage
SQL compatibility mode
Dump table
Add DROP DATABASE
Add CREATE DATABASE / USE
Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER
Add CREATE TABLE
Add IF NOT EXISTS (less efficient as indexes will be generated during table creation)
Add AUTO_INCREMENT value
Add CREATE VIEW
Add CREATE PROCEDURE / FUNCTION / EVENT
Add CREATE TRIGGER
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 BINARY & BLOB
Export time in UTC

CodeGen

Customize default options.

Format

CSV

Customize default options.

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

LaTeX

Customize default options.

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

Microsoft Office

Customize default options.

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

OpenDocument

Customize default options.

OpenDocument Spreadsheet
Put columns names in the first row
Replace NULL with
OpenDocument Text
Dump table
Structure
Relationships
Comments
MIME type
Data
Put columns names in the first row
Replace NULL with

Texy! text

Customize default options

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