localhost
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize
File to import
Location of the text file
(Max: 8,192KiB)
Character set of the file:
armscii8
ascii
big5
binary
cp1250
cp1251
cp1256
cp1257
cp850
cp852
cp866
cp932
dec8
eucjpms
euckr
gb2312
gbk
geostd8
greek
hebrew
hp8
keybcs2
koi8r
koi8u
latin1
latin2
latin5
latin7
macce
macroman
sjis
swe7
tis620
ucs2
ujis
utf16
utf32
utf8
utf8mb4
Imported file compression will be automatically detected from: None, gzip, bzip2, zip
Partial import
Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. This might be good way to import large files, however it can break transactions.
Number of records (queries) to skip from start
Format of imported file
CSV
Open Document Spreadsheet
SQL
Excel 97-2003 XLS Workbook
Excel 2007 XLSX Workbook
XML
Options
Replace table data with file
Ignore duplicate rows
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by
Column names in first row
Options
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)
Options
SQL compatibility mode
NONE
ANSI
DB2
MAXDB
MYSQL323
MYSQL40
MSSQL
ORACLE
TRADITIONAL
Do not use AUTO_INCREMENT for zero values
Options
Column names in first row
Options
Column names in first row
Options
This format has no options
localhost
Databases
SQL
Status
Variables
Charsets
Engines
Privileges
Replication
Processes
Export
Import
Synchronize