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
