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
