Sorin,
Saturday, October 05, 2002, 8:33:23 AM, you wrote:
SC 1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
SC file?
SC My.ini file is below:
SC [mysqld]
SC basedir=C:/mysql
SC datadir=C:/mysql/data
SC enable-local-infile
SC local_infile=1
SC When I perform the LOAD DATA LOCAL INFILE 'file_name.txt' INTO... command
SC from a client application using MyOBDC I receive the error message 1148
SC ('The used command is not allowed with this MySQL version').
SC Where is the mistake?
Add local-infile=1 in the [mysql] section, too.
SC The server version is 4.0.2.-alpha.
SC 2)Other problems appears when I use the 3.23.47 My SQL version.
SC 2.1.
SC In that case LOAD DATA LOCAL INFILE 'file_name.txt' INTO... works but
SC 'file_name.txt' is
SC loaded just if it reside on the server. But notice that I want to load the
SC file ('file_name.txt') from the client machine.
SC Again, what is wrong?
Hm ..
It's strange. I tested it on 3.23.52 and it worked as expected.
SC 2.2.
SC I tried another approach for this problem and I have performed from the
SC client machine a SELECT * FROM... INTO OUTFILE 'file_name.txt' command. Now,
SC everything goes well and LOAD DATA LOCAL INFILE 'file_name.txt' INTO...
SC works fine. It seems my troubles are finished, but... If I run again the
SC same command, another new file with the same name cannot be created (because
SC 'file_name.txt' already exists). How can I remove the older 'file_name.txt',
SC doing this from the client side and using MyODBC?
No, you can't do it with MySQL.
--
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