Re: LOAD DATA LOCAL INFILE

Richard Whitney wrote: Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = "LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '' LINES TERMINATED BY '\\r\\n'"; When I try it using 3.2

RE: LOAD DATA LOCAL INFILE

Hi Richard, Try looking at mysqlimport instead. I'm only taking a punt that it works with that version but the manual doesn't say anything about it being since a certain version. It works as at 3.23.58 so hopefully it may do for .55 Regards David Logan Database Administrator HP Managed Service

RE: LOAD DATA LOCAL INFILE issue

8408 4259 - Fax -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 3:19 PM To: Logan, David (SST - Adelaide) Cc: MySQL List Subject: Re: LOAD DATA LOCAL INFILE issue Well, as you say, that error message means it's been disabled in e

Re: LOAD DATA LOCAL INFILE issue

- Mobile +61 8 8408 4259 - Fax -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 2:37 PM To: Logan, David (SST - Adelaide) Cc: MySQL List Subject: Re: LOAD DATA LOCAL INFILE issue Perhaps the problem is that there is no such option as --enable-local-i

RE: LOAD DATA LOCAL INFILE issue

Hi Michael, Thanks. I rechecked things but porkribs /u2/lcscreative/sql_scripts $ mysql --local-infile -u davidl -p mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 August 2004 2:37 PM To: Logan, David (SST - Adelaide) Cc: MySQL List Subject: Re: LOAD DATA LOCAL INFILE issue Perhaps the problem is

Re: LOAD DATA LOCAL INFILE issue

Perhaps the problem is that there is no such option as --enable-local-infile in the mysql client. I believe you want --local-infile. Client options are detailed in the manual . Michael Logan, David (SST - Adelaide) wrote: Hi Folks, I am having a fe

Re: "LOAD DATA LOCAL INFILE" doesn't show in binlog

Not sure about the 3.x series, but in 4.x, if you build your own mysql, you need to explicitly enable that feature via a configure option. I think binary builds all have it enabled though. Issac - Original Message - From: "David Brännlund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S

Re: Load Data Local Infile problem

This is from the manual. See the 3rd paragraph. > The REPLACE and IGNORE keywords control handling of input records that duplicate > existing records on unique key values. > > If you specify REPLACE, input rows replace existing rows (in other words rows that > has the same value for a primary

Re: Load Data Local Infile problem

[EMAIL PROTECTED] wrote: > I'm load a CSV file with five fields into mysql. It loads up fine. > Problem comes in when I try to refresh the data with updates. > > I grab this file and convert it to CSV every 12 hours. The data shows > past 24 hours only, so basically I'm trying to make a permane

RE: LOAD DATA LOCAL INFILE

Thanks for the help. The problem was the line terminating character. My source files are in DOS format '\r\n' and not the default posix one '\n'. Thanks again. > If it's an option, I would run your datafile through a processor > (sed on unix, ultraedit on windows) to search and replace the strin

RE: LOAD DATA LOCAL INFILE

If it's an option, I would run your datafile through a processor (sed on unix, ultraedit on windows) to search and replace the string "" with \" and try it with fields terminated by ',' optionally enclosed by '"' as mentioned by Mike Johnson's posting (escaped by '\' is default) > -Orig

RE: LOAD DATA LOCAL INFILE

From: Daniel Kiss [mailto:[EMAIL PROTECTED] > Hi all, > > How should I set the parameters of the LOAD DATA LOCAL INFILE > command for a comma separated text file like this: > > "Text field",.4,123 > "Text field with "" included quote",,45 > "Text field with "","" a comma between quotes",1.2,44

Re: LOAD DATA LOCAL INFILE question...

Versions: > > Server is Win32 MySQL max 4.0.16 > > Client is FreeBSD MySQL 4.0.13 -- R > Should work. > What are the server and client versions? > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita

Re: LOAD DATA LOCAL INFILE question...

"Reverend Deuce" <[EMAIL PROTECTED]> wrote: > Egor, > > Thanks for the info. However, like I said, I already have "local-infile=1" > and "set-variable = local-infile=1" in my my.ini on the server. I also have > already done 'show variable like '%infile%' ' and receive "local_infile > ON" in the re

Re: LOAD DATA LOCAL INFILE question...

t set. I run the command line client with --local-infile=1 I still receive the same error regardless of the configuration. -- R - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 22, 2003 5:25 AM Subjec

Re: LOAD DATA LOCAL INFILE question...

"Robert" <[EMAIL PROTECTED]> wrote: > > Having problems using 'LOAD DATA LOCAL INFILE' from a UNIX client talking to > a Win32 server. I've read the documentation several times now and have had > zero success with this command. > > My server has the appropriate permissions configured in the MY.IN

Re: LOAD DATA LOCAL INFILE

Dear Bjoern, it is better to send all mailing list requests in english. Best regards Nils Valentin Tokyo/Japan -Translation: Hi Bioern, es ist bessser alle anfragen an die mailing Liste grundsaetzlich in English zu formulieren. Besten Gruss Nils Valentin Tok

Re: Load Data Local Infile

OS X (10.1 Client and 10.2 Server). My 3.23.51 builds seem to have the same problem. Since PHP access it properly, and the MySQL client can with the proper variable setting, I guess I'll just leave it alone. - John -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John May wrote: The other odd

Re: Load Data Local Infile

). Regards. ROny - Original Message - From: "John May" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 09, 2003 3:31 AM Subject: Re: Load Data Local Infile > The other odd thing I find is that the MySQL manual states: > > > By default, a

Re: Load Data Local Infile

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John May wrote: > The other odd thing I find is that the MySQL manual states: > > > By default, all MySQL clients and libraries are compiled with > --enable-local-infile , to be compatible with MySQL 3.23.48 and before. > > > However, I'm using a 4.0.

Re: Load Data Local Infile

The other odd thing I find is that the MySQL manual states: By default, all MySQL clients and libraries are compiled with --enable-local-infile , to be compatible with MySQL 3.23.48 and before. However, I'm using a 4.0.12-max binary (pre-compiled binary direct from MySQL's site) on one machine

Re: Load Data Local Infile

Can this only be done at build time? Or can I enable it after the fact? If so, how? I tried enable-local-infile as both a setting in my.cnf and when calling safe_mysqld both with no luck. In the meantime, I've found that PHP apparently calls MySQL with the local-infile option on - once I dow

Re: Load Data Local Infile

If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, unless one calls mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0) in the client Read the mysql manual from msyql.com about 'manual_MySQL_Database_Administration.html#LOAD_DATA_LOCAL' Regards

Re: load data local infile

t;[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "rich allen" <[EMAIL PROTECTED]> To: "Terence Ng" <[EMAIL PROT

Re: load data local infile

sound like you may want to add the following to your my.cnf file for MySQL [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote: Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA LOC

Re: load data local infile

Thanks, it works after we recomplied it the enable-local-infile. By default, it is truned off. Cheers, yuyi Rich Allen wrote: try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi G

Re: load data local infile

try adding these line to your my.cnf file (mysql config file) [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Thursday, December 12, 2002, at 09:52 AM, Yuyi Guo wrote: Hi: I am using mysql v4_0_5 both clinet and server. I cannot get load data local infile to work after many differen

re: LOAD DATA LOCAL INFILE

John, Thursday, November 28, 2002, 7:02:58 PM, you wrote: JC> Thanks very much. JC> Following on your suggestions, I then went ahead and put the text file JC> into my directory: JC> /usr/local/mysql JC> so that the file was then /usr/local/mysql/absence.txt JC>

re: LOAD DATA LOCAL INFILE

John, Thursday, November 28, 2002, 2:12:27 AM, you wrote: JC> Here's the question, as succinctly as I can formulate it: JC> The documentation seems to say that one can load a tab-delimited text JC> file located in the current directory of the client host into a

RE: LOAD DATA LOCAL INFILE

The MySQL Manual states the following in the LOAD DATA INFILE section :- If a filename with no leading components is given, the server looks for the file in the database directory of the current database. -Original Message- From: John Connolly [mailto:[EMAIL PROTECTED]] Sent: 28 November

re: load data local infile

Pallavi, Wednesday, November 20, 2002, 11:01:51 AM, you wrote: PAP> i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with PAP> Apache 1.3.24 . PAP> i have encounter following error for load data local infile when i PAP> tried to use an example on mysql site's documentation file : [skip]

Re: load data local infile

Hello Pallavi, > i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with > Apache 1.3.24 . > i have encounter following error for load data local infile when i > tried to use an example on mysql site's documentation file : > mysql> use test; > Database changed > mysql> show tables; > +-

Re: load data local infile

THANKS!! that works! - hcir > I have had luck by removing the word LOCAL from the statement. > > -=Bryan=- >> >> from the mysql command line, load data local infile DOES >> work, am trying to get this to work from Perl >> >> $sth = $dbh->prepare("load data local infile >> '/users/hcir/desktop

Re: load data local infile

Try leaving out the word local. This corrected the same problem on XP Prof. BobJ - Original Message - From: "nellA hciR" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 2:32 PM Subject: load data local infile > i have read several archives/doc

RE: load data local infile

I have had luck by removing the word LOCAL from the statement. -=Bryan=- > -Original Message- > From: nellA hciR [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 11:33 AM > To: MySQL List > Subject: load data local infile > > > i have read several archives/docs on this

Re: Re: LOAD DATA LOCAL INFILE "not allowed this version"?

THANKS VERY MUCH! That worked! - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 10, 2002 9:15 PM Subject: re: Re: LOAD DATA LOCAL INFILE "not allowed this version"? [.] Put lo

re: Re: LOAD DATA LOCAL INFILE "not allowed this version"?

Uriel, Monday, September 09, 2002, 4:21:40 AM, you wrote: C:>mysql -r -N fall02 < \mysqluw\mysql.txt UW> (i.e. using the "mysql" command from DOS, and running a batch file) UW> And I didn't change any configuration defaults since installing mySQL on UW> this machine. Put local-infile=1 in the

Re: LOAD DATA LOCAL INFILE "not allowed this version"?

rom: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]> To: "Uriel Wittenberg" <[EMAIL PROTECTED]>; "Mysql" <[EMAIL PROTECTED]> Sent: Monday, September 09, 2002 8:31 AM Subject: RE: LOAD DATA LOCAL INFILE "not allowed this version"? One can

RE: LOAD DATA LOCAL INFILE "not allowed this version"?

One can disable all LOAD DATA LOCAL commands in the MySQL server by starting mysqld with --local-infile=0. In the case that LOAD DATA LOCAL INFILE is disabled in the server or the client, you will get the error message (1148): The used command is not allowed with this MySQL version http://www.m

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]

Date: Mon, 04 Mar 2002 15:27:58 -0500 <http://us.i1.yimg.com/us.yimg.com/i/space.gif> From: "Thomas Birchmire" <[EMAIL PROTECTED]> <http://us.i1.yimg.com/us.yimg.com/i/space.gif> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] <http://us.i1.yimg.com/us.yimg.com/i

RE: LOAD DATA LOCAL INFILE

[snip] "Texas A&M University","College Station, TX","1999","Design, install, test and run blah, blah.","Whatever Industry" LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; Have you tried this... L

RE: LOAD DATA LOCAL INFILE

[snip] "Texas A&M University","College Station, TX","1999","Design, install, test and run blah, blah.","Whatever Industry" LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'; [/snip] Have you tried t

Re: [Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]]

Hi! > "Thomas" == Thomas Birchmire <[EMAIL PROTECTED]> writes: Thomas> I tried putting --local-infile in my server script and local-infile in the Thomas> /etc/my.cnf file. I also placed a number or logging cammands in the startup Thomas> script hoping to catch lower level messages. There

Re: [Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]]

Thomas Birchmire writes: > I tried putting --local-infile in my server script and local-infile in the > /etc/my.cnf file. I also placed a number or logging cammands in the startup > script hoping to catch lower level messages. There appears to be little > effect on anything. > Regards, Tom Birch

Re: [Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]]

I tried putting --local-infile in my server script and local-infile in the /etc/my.cnf file. I also placed a number or logging cammands in the startup script hoping to catch lower level messages. There appears to be little effect on anything. Regards, Tom Birchmire < -- script and log stuff Sta

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]

Thomas Birchmire writes: > I have the same problem using Linux RedHat 7.2. Just what do I have to > configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on > i686? > The rest of MySQL works as advertised. > Regards Tom Birchmire > > loca-infile is not a variable. The

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]

I have the same problem using Linux RedHat 7.2. Just what do I have to configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on i686? The rest of MySQL works as advertised. Regards Tom Birchmire Michael Widenius <[EMAIL PROTECTED]> wrote: > > Hi! > > > "Sinisa" ==

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> [EMAIL PROTECTED] writes: >> >Description: >> LOAD DATA LOCAL INFILE ... >> >> leads to 'The used command is not allowed with this MySQL version' >> >> This happens regardless of whether I have a >> >> local-infile

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49

Rob Steele writes: > Thanks. I don't think this feature is working as the documentation says > it should. Section 4.2.4 of the manual says: > > By default all MySQL clients and libraries are compiled with | > --enable-local-infile|, to be compatible with MySQL 3.23.48 and before. > >

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49

[EMAIL PROTECTED] writes: > >Description: > LOAD DATA LOCAL INFILE ... > > leads to 'The used command is not allowed with this MySQL version' > > This happens regardless of whether I have a > > local-infile = 1 > > in my /etc/my.cnf. In neither case does the local-infile variable show > up

RE: LOAD DATA LOCAL INFILE (Only loads 20,000 or 41,000 Records)

This worked for me: create table tblZips( id int unsigned not null auto_increment primary key, city char(24) not null default '', state char(2) not null default '', zip char(5) not null default '' ) Type=InnoDB; Saved CSV file as a UNIX (instad of DOS format file) LOAD DATA INF

Re: load data local infile

Yes the data is consistent firstname, lastname, address, city... The data is sent to me in eight different files every day. I want to import the data into a mysql database and set a field that is not included in the txt file. The files are sent to me already organized by region and would like to

RE: load data local infile

Hi, Not quite sure what you mean, but you can use load data infile 'file' into table mytab (col1, col3, col2) to specify in to which columns the data should go. HTH Quentin -Original Message- From: Douglas Potter [mailto:[EMAIL PROTECTED]] Sent: Friday, 4 January 2002 12:27 p.m. To: