7 messages in com.mysql.lists.win32RE: Load Data Infile errs persist 4.0.13| From | Sent On | Attachments |
|---|---|---|
| Jack Dare | 02 Jun 2003 06:25 | |
| Public Folder: MySQL | 02 Jun 2003 06:47 | |
| Mark Matthews | 02 Jun 2003 06:51 | |
| Jack Dare | 02 Jun 2003 08:12 | |
| Januski, Ken | 02 Jun 2003 09:30 | |
| Paul DuBois | 02 Jun 2003 09:49 | |
| Jack Dare | 02 Jun 2003 12:44 |
| Subject: | RE: Load Data Infile errs persist 4.0.13 |
|---|---|
| From: | Jack Dare (jack...@hoytpub.com) |
| Date: | 06/02/2003 08:12:47 AM |
| List: | com.mysql.lists.win32 |
I ran WinMySqlAdmin (apparently for the first time), which created c:\WINNT\my.ini. I added ... [mysqld] set-variable=local-infile=0 ... to it and restarted mySQL. Still no luck. (I don't see any way in WinMySQLAdmin to submit SQL statements from there.)
php4ts.dll is version 4.3.1.1. Is that the library you refer to?
Also tried LOAD DATA LOCAL INFILE from mySQLGUI 1.7.5 and MySQL Control Center 0.8.10-beta and got the same error 1148. Is the problem still related to some sort of client-side config? Is there another client I should try? Thanks much.
-----Original Message----- From: Mark Matthews [mailto:ma...@mysql.com] Sent: Monday, June 02, 2003 8:52 AM
Jack Dare wrote:
Per the release notes, Load Data Local Infile has been enabled by default in 4.0.13 for Windows. I'm running it on a Win2000 Pro machine, using the phpMyAdmin SQL pane to invoke SQL statements. A few postings have suggested hacking the my.ini file, found somewhere in the Windows system files, but there is no such file on my system. (I believe it was a Win98 -> 2000 upgrade.)
Still getting the cheery error: "The used command is not allowed with this MySQL version."
Loading data on the same system using the same method worked fine on 3.23 and 4.0.1. What am I missing?
What version of the mysql client libs is your PHP build linked with? The fix involves _both_ the client libraries _and_ the server. Have you tested 'LOAD DATA INFILE' with the mysql client that ships with the server?
-Mark