←
(Recent tables) ...
There are no recent tables
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.emVudGFvZXA=
cm9vdA==.emVudGFvZXA=
0
zentaoep
Javascript must be enabled past this point
Server: localhost:3306
More
Databases
SQL
Status
Users
Export
Import
Settings
Replication
Variables
Charsets
Engines
Manage your settings
Features
SQL queries
Navigation panel
Main panel
Import
Export
Your preferences will be saved for current session only. Storing them permanently requires
phpMyAdmin configuration storage
.
Import defaults
SQL
CSV
OpenDocument
Import defaults
Customize default common import options
Format of imported file
Default format; be aware that this list depends on location (database, table) and only SQL is always available
csv
docsql
ldi
sql
Character set of the file
iso-8859-1
iso-8859-2
iso-8859-3
iso-8859-4
iso-8859-5
iso-8859-6
iso-8859-7
iso-8859-8
iso-8859-9
iso-8859-10
iso-8859-11
iso-8859-12
iso-8859-13
iso-8859-14
iso-8859-15
windows-1250
windows-1251
windows-1252
windows-1256
windows-1257
koi8-r
big5
gb2312
utf-16
utf-8
utf-7
x-user-defined
euc-jp
ks_c_5601-1987
tis-620
SHIFT_JIS
Partial import: allow interrupt
Allow interrupt of import in case script detects it is close to time limit. This might be a good way to import large files, however it can break transactions.
Partial import: skip queries
Number of queries to skip from start
SQL
Customize default options
SQL compatibility mode
NONE
ANSI
DB2
MAXDB
MYSQL323
MYSQL40
MSSQL
ORACLE
TRADITIONAL
Do not use AUTO_INCREMENT for zero values
CSV
Customize default options
CSV
Replace table data with file
Do not abort on INSERT error
Columns terminated by
Columns enclosed by
Columns escaped by
Lines terminated by
CSV using LOAD DATA
Replace table data with file
Do not abort on INSERT error
Columns terminated by
Columns enclosed by
Columns escaped by
Use LOCAL keyword
auto
yes
no
OpenDocument
Customize default options
OpenDocument Spreadsheet
Column names in first row
Do not import empty rows
Import percentages as proper decimals (12.00% to .12)
Import currencies ($5.00 to 5.00)