load data infile command not allowed problem - revised
I access a msyql server (apache/mysql/php) from my w2k workstation using phpMyAdmin. I do not have command line access. When I use the link to load a local data file it responds that it is not allowed. I read the mysql docs and see it is now disabled by default. In 4.2.4 one paragraph says If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, and just below that in another paragraph it says By default, all MySQL clients and libraries are compiled with --enable-local-infile. Which is it? Default with or without? Evidently it defaults to not enabled. The server is running MySQL-3.23.52. I have added local-infile = 1 to my.cnf in the [client], [mysqld] and [mysql] sections. This has not helped at all. How do I run phpMyAdmin to give me the ability to upload a local data file to a mysql server that doesn't allow this? thanks, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (Then why do I have 8? Somebody help me!) - 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 - 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
load data infile command not allowed problem
I access a msyql server (apache/mysql/php) from my w2k workstation using phpMyAdmin. I do not have command line access. When I use the link to load a local data file it responds that it is not allowed. I read the mysql docs and see it is now disabled by default. In 4.2.4 one paragraph says If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, and just below that in another paragraph it says By default, all MySQL clients and libraries are compiled with --enable-local-infile. Which is it? Default with or without? Evidently it defaults to not enabled. The server is running MySQL-3.23.52. How do I run phpMyAdmin to give me the ability to upload a local data file to a mysql server that doesn't allow this? thanks, -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com [EMAIL PROTECTED] There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (Then why do I have 8? Somebody help me!) - 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
Load Data Infile command
HI all, I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. We just upgraded (?) mysql to 3.23.49. We are running it on Linux Redhat 7.3 The load data local command is turned off by default. I have attempted to follow the instructions in the documentation (Ch. 4.2.4 and others) about this but it has been a dismal failure. I tried the following on restarting mysql: /etc/init.d/mysqld start --local-infile[=1] as in the manual. No luck. I also made some variations on this: --local-infile=1 --local-infile --local-infile(=1) --local-infile=[1] --local-infile=(1) None of these worked. I added the following two lines to the my.cnf file: [client] enable-local-infile and restarted. No luck. Has anyone been able to get this to work? I would really appreciate any help on this since I use the command to load data and it is part of several utility applications I use. Thanks in advance Jon Bertsch - 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
Re: Load Data Infile command
Try this when your logging into mysql, not when starting mysql. This works for me on Linux. mysql --local-infile=1 -u username-p - Original Message - From: Jon Bertsch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 12:02 PM Subject: Load Data Infile command HI all, I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. We just upgraded (?) mysql to 3.23.49. We are running it on Linux Redhat 7.3 The load data local command is turned off by default. I have attempted to follow the instructions in the documentation (Ch. 4.2.4 and others) about this but it has been a dismal failure. I tried the following on restarting mysql: /etc/init.d/mysqld start --local-infile[=1] as in the manual. No luck. I also made some variations on this: --local-infile=1 --local-infile --local-infile(=1) --local-infile=[1] --local-infile=(1) None of these worked. I added the following two lines to the my.cnf file: [client] enable-local-infile and restarted. No luck. Has anyone been able to get this to work? I would really appreciate any help on this since I use the command to load data and it is part of several utility applications I use. Thanks in advance Jon Bertsch - 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 - 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
Re: Load Data Infile command
I'm new to the list so I apologize if this subject has been answered already, I couldn't find a mailing list archive. Where did you look? http://www.mysql.com/documentation/searchlists.html PB - 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
