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

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 <3D075F87.9040406 <email protected>>, bgintz <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 <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?
>>>
>
>chmod() ??
>