Pushkar,
Wednesday, July 31, 2002, 7:00:19 AM, you wrote:
PP> I'm using 3.23.49, and trying to load the menagerie database (online
PP> examples) by executing the example:
PP> LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet;
PP> This is the error I get:
PP> ERROR 1148: The used command is not allowed with this MySQL version
PP> Is this not compatible with 3.23.49?
Since 3.23.49 to enable LOAD DATA LOCAL you must configure MySQL with
--enable-local-infile option or start mysqld with --local-infile
option. You must enable LOAD DATA LOCAL for client too.
http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
