Importing Structure and Data - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 144

Chapter 18 explains phpMyAdmin's interface, for system administrators
to manage privileges.
Usage of 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 author 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 author.csv ile.
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 can see the confirmation screen as follows: