Re: Re: Error Loading File

Whoops :), Yes, this is using phpMyAdmin, trying to use the "Insert data from a textfile into table" function, which uploads a file and the attempts to LOAD DATA INFILE. Like I said below, it worked on PHP 4.1.2, then when upgraded to PHP 4.2.1, it gave the error : "The file '/tmp/phpr4WYQY' must be in the database directory or be readable by all" I ran through the phpMyAdmin scripts and watched it up until it tried to load the file, and it wouldn't read it. The /tmp directory is "drwxrwxrwx" and the files in it are "-rw------", but I don't know how to get those changed in PHP. Anyway, on a different server, I could have sworn I got the same problem but the uploaded files in the /tmp directory were "-rwxrwxrwx". Any ideas? Thanks David Robley wrote:

In article <3D062AEC.4050102@novvia.com>, bgintz@novvia.com says...

I am getting this error with a new install of PHP4.2.1 and Zend Optimizer 1.3.1: The file '/tmp/phpr4WYQY' must be in the database directory or be readable by all I just updated PHP and the Zend Optimizer, and it had worked previously with PHP4.1.2, Any ideas??

Because you are asking on the db list, I'll guess that you are trying to use LOAD DATA INFILE? The file you are trying to load needs to be world readable if it isn't in the database directory. If this isn't the problem, can you be a bit more specific about the circumstances in which this error appears?