Importing Structure and Data - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 149

We can influence the behavior of the import in a number of ways. By default,
importing does not modify existing data (based on primary or unique keys).
However, the Replace table data with ile option instructs phpMyAdmin to use
REPLACE statements instead of INSERT statements, so that existing rows are replaced
with the imported data.
Using Do not abort on INSERT error , INSERT IGNORE statements are generated.
These cause MySQL to ignore any duplicate key problems during insertion. A
duplicate key from the import file does not replace existing data, and the procedure
continues for the next line of CSV data.
We can then specify the character that terminates each column, the character that
encloses data, and the character that escapes the enclosing character. Usually this is \ .
For Lines terminated with option, the auto choice should be tried first as it detects
the end-of-line character automatically. We can also specify manually which
characters terminate the lines. The usual choice is \n for UNIX-based systems, \r\n
for DOS or Windows systems, and \r for Mac-based systems (up to Mac OS 9). If
in doubt, we can use a hexadecimal file editor on our client computer (not part of
phpMyAdmin) to examine the exact codes.