Ok, if anyone else is having the same trouble with PHP 4.2.1, David
Robley's suggestion (Thank you David!) works. I am not to proud to have
missed the obvious :)
If you are having trouble loading files (LOAD INFILE...) with PHP into
MySQL, just do a chmod($file, 0777), and it works. Not sure why this
version of PHP doesn't give full permissions in the /tmp directory, but.
Thanks all.
David Robley wrote:
>In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
>
>>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 <[EMAIL PROTECTED]>, [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?
>>>
>
>chmod() ??
>