On Wed, 2002-08-28 at 20:02, Gerald Clark wrote: > I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Sorry, I don't understand: why would mysql have access to a file when I run LOAD DATA LOCAL... and not when I run it without the LOCAL? If I run it with LOCAL the data is added to the table without a problem -- well not entirely without a problem, see my post about NULL values. (I actually have no idea what the LOCAL does so this may be a dumb question) Thanks for the help. p.s. just in case that wasn't what you meant: M8ram is my username, so on my (RH7.3) Linux box /home/M8ram is simply my home-directory... -- # 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