Importing Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 132

Requirements
Relying on the MySQL server has some consequences. Using LOAD DATA INFILE
requires that the logged-in user possess a global FILE privilege. Also, the file itself
must be readable by the MySQL server's process.
Chapter 18 explains phpMyAdmin's interface to privileges
management for system administrators.
Using the LOCAL modifier in LOAD DATA LOCAL INFILE must be allowed by the
MySQL server and MySQL's client library used by PHP.
Both the LOAD methods are available from the phpMyAdmin LOAD interface,
which tries to choose the best possible default option.
Using the LOAD DATA Interface
We select Import from the authors table menu. Choosing CSV using LOAD DATA
brings up the following dialog:
The available options have already been covered in the CSV section.
In the familiar Location of the text file question, we choose our authors.csv file.
Finally, we can choose the LOAD method, as discussed earlier, by selecting the Use
LOCAL keyword option. We then click Go .
If all goes well, we see the confirmation screen: