phpMyAdmin setup

Customize import defaults

Import defaults
SQL
CSV
Open Document

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
Character set of the file
Partial import: allow interrupt Allow interrupt of import in case script detects it is close to time limit. This might be 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
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

Open Document

Customize default options

Open Document 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)