after attemping to insert data from a textfile into the table, i get this error message:
LOAD DATA LOCAL INFILE '/var/tmp/phpiDnVUE' REPLACE INTO TABLE `lyrics` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
File '/var/tmp/phpiDnVUE' not found (Errcode: 0)
i think it is a phpmyadmin problem, a problem writing the temp file into the temp directory, but i'm not sure. can someone help me out on this? the techs at my webhosting company say that this directory has write permission by all.