Help with pathnames on a LOAD DATA INFILE

2005-06-20 Thread Brian Dunning
I've got a GoDaddy virtual dedicated server and I'm trying to run a LOAD DATA INFILE, but I keep getting Can't get stat of '/home/httpd/ vhosts/04planet.info/httpdocs/test.txt' (Errcode: 13) As you can see from that error message, I've uploaded my data file to the httpdocs directory and

Re: Help with pathnames on a LOAD DATA INFILE

2005-06-20 Thread Brian Dunning
I just solved my own problem. For the benefit of others, I only needed to set permissions to 755 for the directory containing my data file. Works fine now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Help with pathnames on a LOAD DATA INFILE

2005-06-20 Thread mfatene
hi, havant't you an automatic naming to .htm such as test.txt.htm rather than test.txt ? it's an upload problem. Can you access your file online ? Mathias Selon Brian Dunning [EMAIL PROTECTED]: I've got a GoDaddy virtual dedicated server and I'm trying to run a LOAD DATA INFILE, but I keep

Re: Help with pathnames on a LOAD DATA INFILE

2005-06-20 Thread Michael Kruckenberg
First, remember when MySQL interacts with the filesystem it does so with the privileges of the mysql user (or whatever user is running the database). You'll have problems if that user doesn't have permissions in that dir. I'm not sure what OS GoDaddy runs, but if it's a flavor of Linux the