Server: localhost
Databases
SQL
Status
Variables
Charsets
Engines
Processes
Export
Import
View dump (schema) of databases
Export
Select All
/
Unselect All
eu_eu
information_schema
CSV
CSV for MS Excel
Microsoft Excel 2000
Microsoft Word 2000
LaTeX
Open Document Spreadsheet
Open Document Text
PDF
SQL
YAML
Options
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Replace NULL by
Put fields names in the first row
Options
Replace NULL by
Put fields names in the first row
Excel edition
Windows
Excel 2003 / Macintosh
Options
Replace NULL by
Put fields names in the first row
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
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
Add custom comment into header (\n splits lines)
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
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add CREATE PROCEDURE / FUNCTION
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
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.
Open new phpMyAdmin window