Notice: Array to string conversion in /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php on line 179

Warning: Cannot modify header information - headers already sent by (output started at /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php:179) in /home/matthew/public_html/phpMyAdmin/libraries/header_http.inc.php on line 24

Warning: Cannot modify header information - headers already sent by (output started at /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php:179) in /home/matthew/public_html/phpMyAdmin/libraries/header_http.inc.php on line 25

Warning: Cannot modify header information - headers already sent by (output started at /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php:179) in /home/matthew/public_html/phpMyAdmin/libraries/header_http.inc.php on line 27

Warning: Cannot modify header information - headers already sent by (output started at /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php:179) in /home/matthew/public_html/phpMyAdmin/libraries/header_http.inc.php on line 28

Warning: Cannot modify header information - headers already sent by (output started at /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php:179) in /home/matthew/public_html/phpMyAdmin/libraries/header_http.inc.php on line 29

Warning: Cannot modify header information - headers already sent by (output started at /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php:179) in /home/matthew/public_html/phpMyAdmin/libraries/header_http.inc.php on line 30

Warning: Cannot modify header information - headers already sent by (output started at /home/matthew/public_html/phpMyAdmin/libraries/Error.class.php:179) in /home/matthew/public_html/phpMyAdmin/libraries/header_http.inc.php on line 33
phpMyAdmin setup

phpMyAdmin setup

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)