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:[EMAIL PROTECTED]] > Sendt: 3. januar 2002 15:40 > Til: [EMAIL PROTECTED] > Kopi: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
