Re: [PHP-DB] Re: Error Loading File From: Bryan Gintz (bgintz <email protected>)
Date: 06/12/02

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 <email protected>>, bgintz <email protected> 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?
>