Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : phpMyAdmin: Insert data from textfile error!!!

[mioi]

after attemping to insert data from a textfile into the table, i get this error message:

Error

SQL-query :

LOAD DATA LOCAL INFILE '/var/tmp/phpiDnVUE' REPLACE INTO TABLE `lyrics` FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

MySQL said:


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.

[wmac]

Sometimes phpMyAdmin fails to restore dum files specially when it contains binary data.

If you have SSH access try restoring it using shell commands:

mysql -u username -p databasename < ./dumpfilename

(you will need to ftp your dumpfile).

This works on 99% of cases which phpMyAdmin does not work.


Mac