RE: mysql LOAD DATA INFILE

; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE [snip] 70050;451 70322;451 LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' [/snip] [/snip] I am going to recommend that you specify which columns the data goes

RE: mysql LOAD DATA INFILE

[snip] 70050;451 70322;451 LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' [/snip] [/snip] I am going to recommend that you specify which columns the data goes into LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE

mysql LOAD DATA INFILE

When I come across this error: The used command is not allowed with this MySQL version Does this mean that I need a whole different verison of MySQL, or just a different compile? The command was 'LOAD DATA INFILE' and I was doing it through phpMyAdmin. Thanks, -Mike -- MySQL General

RE: mysql LOAD DATA INFILE

[snip] Sorry, that is the error - my mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n' [/snip] Mike, could we see just a bit of the php9GOwvw file...just out of curiosity -- MySQL General Mailing List

Re: mysql LOAD DATA INFILE

' I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version remedy the issue? Thanks, -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:42 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE PHPMyAdmin

FW: mysql LOAD DATA INFILE

. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Sorry, that is the error - my mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE

RE: mysql LOAD DATA INFILE

Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:42 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word LOCAL and it should work fine. -Original Message- From

FW: mysql LOAD DATA INFILE

, 2003 3:24 PM To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Ah. No wonder it dinna work. Neither did specifying the columns as Jay suggested. I also have no choice but to do it through the browser - I don't have command line access on the server

RE: mysql LOAD DATA INFILE

[snip] It's a little messy but that's the only other way I can think of doing it. Sorry. [/snip] If he has the file locally to himself he can do this via phpMyAdmin through the load text file option. Depending on the version there is always a way to load files ... even to remote servers For

RE: mysql LOAD DATA INFILE

[snip] I see you still have the word LOCAL in there. Did you try and remove it? To do that in PHPMyAdmin you will need to run the import so you get the error message and then copy and paste it into the SQL section of the PHPMyadmin tool. Delete the world LOCAL and then run the query. It should

RE: mysql LOAD DATA INFILE

08, 2003 4:08 PM To: [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Oh and just a note. This solution won't work if you are uploading the file to the server through the browser. You will need to put the file on the server and adjust the commands PATH accordingly. -Original

RE: mysql LOAD DATA INFILE

15,000 of them. :) -Mike -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:58 PM To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE [snip] Sorry, that is the error - my mistake. I am getting

RE: mysql LOAD DATA INFILE

, -Mike -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 4:30 PM To: [EMAIL PROTECTED] Subject: FW: mysql LOAD DATA INFILE Then the only way you can do it that I can think of is to write a PHP script to do basically what PHPMyAdmin is trying

RE: mysql LOAD DATA INFILE

PHPMyAdmin uses the LOAD DATA LOCAL INFILE command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across

RE: mysql LOAD DATA INFILE

, 2003 3:07 PM To: '[EMAIL PROTECTED]' Subject: FW: mysql LOAD DATA INFILE I see you still have the word LOCAL in there. Did you try and remove it? To do that in PHPMyAdmin you will need to run the import so you get the error message and then copy and paste it into the SQL section of the PHPMyadmin

MYSQL: LOAD DATA INFILE and 'äöü' Characters

MYSQL: I have problems with importing data including characters like 'äöü'. These characters where translated to some other unusable characters. In the command line with a single insert statement the 'äöü' characters are accepted! Can help someone ? Thanks Enrico Kratter Alpenblickstrasse 30

MySQL Load Data Infile

I have a table that has following fields id (auto increment) date appleprice orangeprice pearprice When I try to LOAD DATA INFILE with this file using comma as field delimiter and newline as end of row 2000-01-04,281.08,5.27,430.05 2000-01-05,280.06,5.14,421.98 2000-01-06,279.99,5.13,408.59

Re: MySQL Load Data Infile

You need to specify the columns you're loading, if they aren't all the columns in the table in the same order. So, you need to add (date, appleprice, orangeprice,pearprice) at the end of your LOAD DATA INFILE statement. As for only loading one row, I'd guess your input file line endings

Re: MySQL Load Data Infile

At 13:13 -0600 2/22/02, Craig Westerman wrote: I have a table that has following fields id (auto increment) date appleprice orangeprice pearprice When I try to LOAD DATA INFILE with this file using comma as field delimiter and newline as end of row You need to add the column list: ... INTO