Importing Structure and Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 141

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 see the confirmation screen:

This screen shows the exact LOAD DATA LOCAL INFILE statement used. Here is what
has just happened in detail:

•
•

We chose author.csv .
The contents of this file were transferred over HTTP and received by the
web server.
The PHP component inside the web server saved this file in a work directory
(here /mnt/san/tmp/ ) and gave it a temporary name.
phpMyAdmin informed of the location of this working file, built a LOAD
DATA LOCAL INFILE command and sent it to MySQL.
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 in the results page.

•

•

•

Web Server Upload Directories
To get around cases where uploads are completely disabled by a web server's PHP
configuration or where upload limits are too small, phpMyAdmin can read upload
files from a special directory located on the web server's file system. This mechanism
is applicable for SQL and CSV imports.