On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote: > As it says in the documentation, "If the LOCAL keyword is specified, > the file is read from the client host. If LOCAL is not specified, the > file must be located on the server." That means that with LOCAL the > MySQL *client* must be able to access the file, but without LOCAL > it's the MySQL *server* that needs access. The MySQL server probably > doesn't (or at least shouldn't) have access to your home directory.
Thx, I read that part but it didn't make much sense to me, but I think I'm starting to see the light... As I read somewhere else in the documentation the mysql-daemon is run as user nobody who has very little rights. So this user would indeed have no rights for the specified file. I thought the root user was running the mysql-daemon and that therefor both the server and client (which are both running on my desktop computer) would have access to the file. However according to ps -aux (I'm running mysql on a RH Linux box) the only processes I see are owned by a user called mysql. Perhaps RH changed the username, they change quite a bit in certain packages so this wouldn't surprise me. Anyway, it's working now, it's even making sense to me, so thanks a lot! Regards -- # Mertens Bram "M8ram" <[EMAIL PROTECTED]> Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # # A priest advised Voltaire on his death bed to renounce the devil. # # Replied Voltaire, "This is no time to make new enemies." # --------------------------------------------------------------------- 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
