admin, Saturday, August 10, 2002, 6:31:56 AM, you wrote: a> Many of you suggested that, in regards to my problem with LOAD DATA a> [LOCAL] INFILE ... , I may have permissions problems. I checked with a> the host and the reply was, "You have access to do all commands except a> for the "grant" command." So it would appear that I SHOULD be able to a> load data from my laptop. But as of yet I cannot.
Do you have all privileges on the specific database or on the all databases (global privileges)? To use LOAD DATA you must have FILE privilege. It's a global privilege, not a database level privilege. a> To reply to some of your more specific questions: a> Yes, the file is definitely located in the directory specified. Using a> \\ instead of a single \ in the path seems to be a good thing, but the a> file is still not found. I keep getting Errcode: 2 and using "perror" a> only tells me that there's an error in my "Perror" code, so I have no a> idea what Errcode 2 is (though it is likely something telling me it a> could not find the file!) $ perror 2 Error code 2: No such file or directory It means the MySQL can't find file on your client box (as I remember error 2 occured when you used LOAD DATA LOCAL). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
