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

If all goes well, we can see the confirmation screen as shown in the following screenshot:
This screen shows the exact LOAD DATA LOCAL INFILE statement used. Here is
what has happened:
1. We chose author.csv .
2. The contents of this file were transferred over HTTP and received by the
web server.
3. The PHP component inside the web server saved this file in a work directory
(here /opt/php-upload-tmp/ ) and gave it a temporary name.
4. phpMyAdmin, informed of the location of this working file, built a LOAD
DATA LOCAL INFILE command, and sent it to MySQL. Note that just one
query was executed, which loaded many rows.
5. The MySQL server read and loaded the contents of the file into our target
table. It then returned the number of affected rows ( 2 ), which phpMyAdmin
displayed on the results page.
Importing other formats
In addition to SQL and CSV formats, phpMyAdmin can import Open Document
Spreadsheet and XML files. However, these files need to have been exported by
phpMyAdmin itself, or closely follow what phpMyAdmin does when exporting.
Open Document Spreadsheet
By default, when we export via phpMyAdmin in this format, the Put column names
in the first row option is not marked. This means that the exported file contains only
data. At import time, a corresponding option The first line of the ile contains the
table column names is offered and should not be marked if the file does not contain
the column names in its first line.