As a newcomer to MySql, I have struggled through the install and am working my way through the tutorial. My environment: Win2000 MySql version 3.23.51-nt
My.ini: [mysqld] # set basedir to installation path, e.g., c:/mysql basedir=c:/mysql # set datadir to location of data directory, # e.g., c:/mysql/data or d:/mydata/data datadir=c:/mysql/data # turn load data local option on local-infile=1 I am attempting to load table = menagerie from a text file name "pet.txt". To make this work I have had to do the following: 1. Include local-infile=1 option on the login to mysql. Why is this not picked from My.ini? C:\mysql\bin>mysql -u jarkema -p --local-infile=1 2. Fully qualify the input file on the load data command. Why is the data path not being picked up from My.ini? mysql> load data local infile "c:/mysql/data/pet.txt" into table pet; If I don't fully qualify the input file name I get: mysql> load data local infile "pet.txt" into table pet; ERROR: File 'pet.txt' not found (Errcode: 2) It doesn't appear that my.ini is being used by mysql. Can anyone explain why? Thanks, Jerry --------------------------------------------------------------------- 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