phpmyadmin - Insert data from a textfile into table

[ruiner17]

Hi. I'm trying to import my old shouts from a text file to a new shoutbox mysql database. I followed the following directions:

• Click on the shoutbox table on the left.
• Click on 'insert textfiles into table'.
• Download a copy of your shouts.txt file to your local computer.
• Select that file in the 'location of the textfile' field.
• Set 'Fields terminated by' to "|" without the quotes.
• Remove the " from 'Fields enclosed by'.
• Column names should be "name, shout, timestamp, url" without the quotes.
• Click Submit!

but I recieve the following error:

Database db_jcarlos - table shoutbox running on localhost
Error

SQL-query :

LOAD DATA LOCAL INFILE '/tmp/phpSWS6fL' INTO TABLE shoutbox FIELDS TERMINATED BY '|' (name, shout, timestamp, url)

MySQL said:

File '/tmp/phpSWS6fL' not found (Errcode: 0)

Any ideas?

[floR]

Stupid question perhaps, but does the file '/tmp/phpSWS6fL' exist? Since PHPMyAdmin apparently can't find it.

[ruiner17]

i have no idea why it's looking for that particualr file. i actually just ended up manually formating the text file into something that phpmyadmin would understand.

[floR]

It looks like it's a temp file... can't you save the file to /somefolderonyourpc/phpinput.txt and use that as input?
I usually have no trouble whatsoever inputting a file which resides on my pc where phpmyadmin is also running...