Re: Re: Error Loading File
| From: | David Robley | Date: | Thu, 13 Jun 2002 00:31:14 +0000 |
| Subject: | Re: Re: Error Loading File | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19773@lists.php.net to get a copy of this message | ||
In article <3D075F87.9040406@novvia.com>, bgintz@novvia.com 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@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?
> >
chmod() ??
--
David Robley
Temporary Kiwi!
Quod subigo farinam