SV: [PHP-DB] The file '/tmp/phpxw2cJS' must be in the database directory or be readable by all

Looks like an uploaded file... (Did you make a page that lets you upload the file then run it into your table?) Upload the file manually, chmod it to 777 or whatever... But when you uploaded it, the file has your default read/write permissions that should work within mysql. Then you should be able to load it within mysql, only from the new location. If your chrooted ftp enviroment is /home/hayan/ And you uploaded your file there, then you would do something like: LOAD DATA LOCAL INFILE "/home/hayan/nameoftxtfile.txt" INTO TABLE tblname ; > -----Opprinnelig melding----- > Fra: Bogdan Stancescu [mailto:mgv@fx.ro] > Sendt: 3. januar 2002 15:40 > Til: hayan@ureach.com > Kopi: php-db@lists.php.net > Emne: Re: [PHP-DB] The file '/tmp/phpxw2cJS' must be in the database > directory or be readable by all > > > Do you have control over where the file to be loaded is located? If so, > simply create a directory in your user's home, and do what the > error message > says :-) > > HTH > > Bogdan > > Hayan Al Mamoun wrote: > > > I have this error when I try to execute "Load Data Infile .. " > > statement, although temp directory location is set by the > > hosting company, What shall I do??? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >