On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: > Put into my.cnf file : > [mysql] > local-infile=1 > > or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following command to load the data-file: mysql> LOAD DATA LOCAL INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; Query OK, 3 rows affected (0.19 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 But when I use the above command without the LOCAL option it displays the following error: mysql> LOAD DATA INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; ERROR 1045: Access denied for user: 'M8ram@localhost' (Using password: NO) Is this 'normal behaviour'? About the second suggestion: where should this file be located? Is it possible that it does not exist yet? If so can I create a file named "my.cnf" with a text-editor (like KWrite) and put it in my home directory? Thanks for the help! -- # 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