Exporting Structure and Data (Backup) - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 129

• Dump binary columns in hexadecimal notation : This option makes
phpMyAdmin encode the contents of BLOB columns in 0x format. Such
a format is useful as, depending on the software that will be used to
manipulate the export file (for example a text editor or mail program),
handling a file containing 8-bit data can be problematic. However, using this
option will produce an export of BLOB column type that is twice the size.
• Dump TIMESTAMP columns in UTC : This is useful if the export file is to be
imported back on a server located in a different time zone.
CSV
This format is understood by a lot of programs, and you may find it useful for
exchanging data. Note that it is a data-only format—no SQL structure here.
The available options are:
• Columns separated with : We put a comma here, which means that a
comma will be placed after each column. The default value comes from
$cfg['Export']['csv_separator'] .
• Columns enclosed with : We place an enclosing character here (double
quotes) to ensure that a column containing the terminating character
(comma) is not taken for two columns. The default value comes from
$cfg['Export']['csv_enclosed'] .
• Columns escaped with : If the export generator finds the Columns enclosed
with character inside a column, this character will be placed before it in order
to protect it. For example, "John \"The Great\"Smith" . The default value
comes from $cfg['Export']['csv_escaped'] .