Re: LOAD DATA INTO not working

ot;Jerry" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 12:47 PM Subject: Re: LOAD DATA INTO not working > > I can perfectly connect to the myqsl server, with this specific user .. he > can select/insert/update/whatever, but he gets permission den

Re: LOAD DATA INTO not working

The file resides in /var/tmp (I am using the full path): LOAD DATA INFILE '/var/tmp/whatever' INTO TABLE ... -a On Thu, 20 Feb 2003, Ahmed S K Anis wrote: > If the File resides in the same machine as the Database, it should > work. > If the file resides where the your client program resides, t

Re: LOAD DATA INTO not working

I can perfectly connect to the myqsl server, with this specific user .. he can select/insert/update/whatever, but he gets permission denied errors, when trying to do a load data infile ;-/ The user has: GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD 'password' GRANT SELECT,

Re: LOAD DATA INTO not working

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO 'myuser'@'localhost' IDENTIFIED BY 'password' mysql -u myuser -ppassword Does that do it ? Jerry - Original Message - From: "Andy De Petter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 20,

Re: load data

At 19:00 -0500 2/15/03, Richard Nagle wrote: where would one put a .txt file to have mysql load it.? what dir. would it have to be in.? Anywhere you like, but the LOAD DATA statement must specify the pathname correctly so that MySQL can find it. Read the manual section on LOAD DATA, which lists

RE: Re: Load Data Infile problem.

on DOS/Windows): LINES TERMINATED BY '\r\n' Note that you may need to double the \ characters to get them passed through PHP properly to MySQL. Thanks in advance. -Mensaje original- De: Paul DuBois [mailto:[EMAIL PROTECTED]] Enviado el: Viernes, 14 de Febrero de 2003 04:43 p.m.

Re: Re: Load Data Infile problem.

The thing is that it will import one, and skip one full record each time. But the one it inserts, is correctly inserted with the ; and the decimal point correct. Any idea why it might be pasing one row and adding one? This is typically a problem of not having the line-ending terminator specified

Re: LOAD DATA LOCAL

Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 2:07 PM Subject: re: LOAD DATA LOCAL > On Friday 03 January 2003 22:38, Stefan Hinz wrote: > > > I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD > > DATA L

Re: LOAD DATA LOCAL

PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 03, 2003 11:19 PM Subject: Re: LOAD DATA LOCAL I posted the same question two weeks ago. The only suggestion was to add flags to the my.cnf file: [mysqld] local-infile=1 [mysql] local-infile=1 But this didn't work. I'v

re: LOAD DATA LOCAL

On Friday 03 January 2003 22:38, Stefan Hinz wrote: > I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD > DATA LOCAL (keep getting error 1148). I tried: > > - Starting the server with --local-infile=1, and with --local-infile. > - Starting the mysql client with --local-infile

Re: LOAD DATA LOCAL

I posted the same question two weeks ago. The only suggestion was to add flags to the my.cnf file: [mysqld] local-infile=1 [mysql] local-infile=1 But this didn't work. I've tried using the flags on startup of MySQL as shown in the manual but this fails as well. We were running 3.23.49. I t

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 infile...

Try doubling up your forward slashes so that they stop being special characters. c:\temp -> c:\\temp -bill Lisa He wrote: Hi, I have a question with regards to Load data infile... I have a .txt file containging only path names e.g " C:\temp " in the bodytext. this file is imported into the

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 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 ch

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 comman

Re: LOAD DATA command

uford - Original Message - From: "Insanely Great" <[EMAIL PROTECTED]> To: "Padma kuruganti" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, December 07, 2002 12:32 PM Subject: Re: LOAD DATA command > Greetings... > > Are you using Windows to con

Re: LOAD DATA command

Greetings... Are you using Windows to connect to the MySQL. Then you can try SQLyog at http://www.webyog.com/sqyog/download.html It will help you a lot in these works and you dont have to write queries also. Rgds Insane - Original Message - From: "Padma kuruganti" <[EMAIL PROTECTED]> To:

Re: LOAD DATA command

i believe that this security issue came up with the .51 version of mysql you can remove this block by adding this to your my.cnf file [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Friday, December 6, 2002, at 10:16 AM, Padma kuruganti wrote: Hi I just downloaded version 3.23.53 fo

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: Re: load data worked with warnings

Pallavi, [Please keep replies on-list. It helps other people, my mail rules keep you separated from paying clients, and the list archives are complete] > actually i created a new file by vim & then did cut & paste . =therein lies the problem. If you compare the listing below with the expected out

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 worked with warnings

Pallavi, > mysql> load data infile "pet.txt" into table pet; > ERROR 1105: File './test/pet.txt' not found (Errcode: 2) > mysql> load data infile "pet.txt" into table pet; > Query OK, 8 rows affected (0.00 sec) > Records: 8 Deleted: 0 Skipped: 0 Warnings: 4 > > mysql> select * from pet; > +

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 infile syntax

>If the data contains "\", then database will automatically takes "\" >away and shift 1 byte left. >My data will mass up. That is why I still need "\" Does your data actually include backslash characters? If you want to import them as they are, you definitely don't want to ESCAPE BY them. Esca

Re: load data infile syntax

At 12:38 -0500 11/6/02, Vivian Wang wrote: I tried, db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'"); db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by

Re: load data infile syntax

I tried, db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'"); db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\n

Re: load data infile syntax

At 11:18 -0500 11/6/02, Vivian Wang wrote: This is my statement using python, db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'"); Is python problem? not sure. Looks like what's happening is that Python it

Re: load data infile syntax

This is my statement using python, db.query("load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'"); Is python problem? not sure. At 10:01 AM 11/6/2002 -0600, Paul DuBois wrote: At 10:03 -0500 11/6/02, Vivian Wang wrote:

Re: load data infile syntax

At 10:03 -0500 11/6/02, Vivian Wang wrote: I did my testing. If I use ESCAPED BY '\\', I got 1064, "You have an error in your SQL syntax near ''' at line 2" Using ESCAPED BY '\', then no error and result is fine. If the data contains "\", then database will automatically takes "\" away and shift

Re: load data infile syntax

I did my testing. If I use ESCAPED BY '\\', I got 1064, "You have an error in your SQL syntax near ''' at line 2" Using ESCAPED BY '\', then no error and result is fine. If the data contains "\", then database will automatically takes "\" away and shift 1 byte left. My data will mass up. That is

Re: load data infile syntax

At 14:38 -0500 11/5/02, Vivian Wang wrote: The syntac ESCAPED BY of load data infile is wrong in http://www.mysql.com/doc/en/LOAD_DATA.html. the [ESCAPED by '\\'] should be: [ESCAPED BY '\'] Why do you say that? - Before post

Re: LOAD DATA INFILE problem

* Clayburn W. Juniel, III <[EMAIL PROTECTED]> [021012 07:30]: > >I am attempting to delete a table from a database, > >then recreate it and load data into the table. > >The drop and create commands are working properly, > >here's a screen dump: <..> > >mysql> LOAD DATA INFILE > >"

Re: LOAD DATA INFILE problem

On Friday, Oct 11, 2002, at 15:21 America/Phoenix, Tim Johnson wrote: > Hello All: > I am attempting to delete a table from a database, > then recreate it and load data into the table. > The drop and create commands are working properly, > here's a screen dump: > > mysql> DROP TA

re: LOAD DATA INFILE problem

Tim, Saturday, October 12, 2002, 1:21:59 AM, you wrote: TJ> I am attempting to delete a table from a database, TJ> then recreate it and load data into the table. TJ> The drop and create commands are working properly, TJ> here's a screen dump: TJ> mysql> DROP TABLE IF EXISTS tes

Re: load data

Jorge Martinez wrote: > I load a table whit the query: > > LOAD DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t' LINES > TERMINATED BY '\n'; > > the file: > > 211ppp222 > 222ooo333uuuo > > and more > > the problem is, the last field in the

re: Load Data from multiple sources

William, Wednesday, September 25, 2002, 11:26:20 AM, you wrote: WM> Can someone tell me if I can load only one column of data from a tab WM> delimited text file into MySQL 4.0? If this column is first in the text file, yes. But you get warnings. WM> If so, then can I assume that I can WM> load

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: LOAD DATA not a valid command?

Michael, Sunday, September 08, 2002, 10:21:20 PM, you wrote: MB> I just installed Max v3.23.52-nt and it is working. However, in following MB> the tutorial, I created a text file and tried to use the Load Data command, MB> which returned an error: "ERROR 1148: The used command is not allowed wi

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 into table from file or how to set the local-infile=1

It shoul d be running as user mysql . Mertens Bram wrote: >On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote: > >>As it says in the documentation, "If the LOCAL keyword is specified, >>the file is read from the client host. If LOCAL is not specified, the >>file must be located on the server."

Re: Re: load data into table from file or how to set the local-infile=1

Mertens, Wednesday, August 28, 2002, 6:52:12 PM, you wrote: MB> On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: >> Put into my.cnf file : >> [mysql] >> local-infile=1 >> >> or start mysql client with --local-infile=1 option. MB> I tried the first option and it works when use the following comma

Re: load data into table from file or how to set the local-infile=1

On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote: > As it says in the documentation, "If the LOCAL keyword is specified, > the file is read from the client host. If LOCAL is not specified, the > file must be located on the server." That means that with LOCAL the > MySQL *client* must be able t

Re: load data into table from file or how to set the local-infile=1

On 28 Aug 2002, at 20:07, Mertens Bram wrote: > Sorry, I don't understand: why would mysql have access to a file when I > run LOAD DATA LOCAL... and not when I run it without the LOCAL? As it says in the documentation, "If the LOCAL keyword is specified, the file is read from the client host. I

Re: load data into table from file or how to set the local-infile=1

On Wed, 2002-08-28 at 20:02, Gerald Clark wrote: > I doubt mysql as access to /home/M8ram/testmysql/pet.txt. Sorry, I don't understand: why would mysql have access to a file when I run LOAD DATA LOCAL... and not when I run it without the LOCAL? If I run it with LOCAL the data is added to the tab

Re: load data into table from file or how to set the local-infile=1

I doubt mysql as access to /home/M8ram/testmysql/pet.txt. Mertens Bram wrote: >On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: > >>Put into my.cnf file : >>[mysql] >>local-infile=1 >> >>or start mysql client with --local-infile=1 option. >> > >I tried the first option and it works when use the f

Re: load data into table from file or how to set the local-infile=1

On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: > Put into my.cnf file : > [mysql] > local-infile=1 > > or start mysql client with --local-infile=1 option. I tried the first option and it works when use the following command to load the data-file: mysql> LOAD DATA LOCAL INFILE '/home/M8ram/testm

Re: load data into table from file or how to set the local-infile=1

Mertens, Wednesday, August 28, 2002, 10:54:12 AM, you wrote: MB> I was following the example in the manual (the menagerie database) but I MB> can not load a file into the table, i get the following error: MB> mysql> LOAD DATA LOCAL INFILE "~/testmysql/pet.txt" INTO TABLE pet; MB> ERROR 1148: The

Re: Load Data Infile

I would use some sort of scripting language (PHP for example) to format the date, and have that script import the data into your table, rather than using LOAD DATA INFILE. If you post a sample of how your data file is formatted, someone will gladly help you out. You might want to post this to the

Re: Load Data Infile

Serge, Why didn't you give this information/constraint in the first place? Why now complain that it is not a "very automated" solution? Why narrow your mind to assume that the problem is with MySQL? "Them" are going to be a problem to many of their 'clients' then, because CCYY-MM-DD is the inter

Re: Load Data Infile

Serge Paquin wrote: > This is the only option? That's not a very automated process and I must import this >data once a day. I also will not be able to get them to reformate their data since >I'm only one of many many people downloading everyday. Is their no way for load data >to do this aut

Re: Load Data Infile

On Tue, Aug 20, 2002 at 04:40:25PM -0400, Serge Paquin wrote: > This is the only option? That's not a very automated >process and I must import this data once a day. I also will >not be able to get them to reformate their data since I'm >only one of many many people downloading everyday. Is the

Re: Load Data Infile

This is the only option? That's not a very automated process and I must import this data once a day. I also will not be able to get them to reformate their data since I'm only one of many many people downloading everyday. Is their no way for load data to do this automaticaly? Serge. On Tue

Re: Load Data Infile

Hello Serge, > I am having troubles with Load Data Infile and cannot figure out the problem. I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So when I import I only get '-00-00' rather than the date. How can I tell MySQL what the format is? > > I have read

Re: LOAD DATA, \N, and auto_increment

Hi! > "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes: Benjamin> How-to-repeat: shell> cat >/tmp/in < 1 Benjamin> 2 Benjamin> \N Benjamin> \N Benjamin> 10 Benjamin> \N Benjamin> EOF shell> chmod a+r /tmp/in mysql> CREATE TABLE ntest2 ( a INT UNSIGNED NOT NULL AUTO_INCREMENT

Re: LOAD DATA, \N, and auto_increment

Hi. On Sun 2002-08-18 at 21:58:04 +0200, [EMAIL PROTECTED] wrote: > Hello. > > On Sun 2002-08-18 at 18:53:46 +0200, [EMAIL PROTECTED] wrote: > > To Whom it May Concern, > > I sincerely doubt it's relevant, but i'm running MySQL 3.23.52 on > > Linux 2.4.18 (RedHat build 5). Client and se

Re: LOAD DATA, \N, and auto_increment

>Hello. > >On Sun 2002-08-18 at 18:53:46 +0200, [EMAIL PROTECTED] wrote: >> To Whom it May Concern, >> I sincerely doubt it's relevant, but i'm running MySQL 3.23.52 on >> Linux 2.4.18 (RedHat build 5). Client and server are on the >>same machine >> and communicate via a Unix domain s

Re: LOAD DATA, \N, and auto_increment

Hello. On Sun 2002-08-18 at 18:53:46 +0200, [EMAIL PROTECTED] wrote: > To Whom it May Concern, > I sincerely doubt it's relevant, but i'm running MySQL 3.23.52 on > Linux 2.4.18 (RedHat build 5). Client and server are on the same machine > and communicate via a Unix domain socket. >

Re: Load Data Warnings

On 15 Aug 2002, at 10:45, Brian Fahey wrote: > How do I find out what the warnings are? I haven't been able to find > anything about what they are. Paul DuBois has a Perl script, load_diag.pl, that could answer your question: http://www.kitebird.com/mysql-cookbook/ Or you could export the d

RE: load data infile --- problem

Try putting the file into the MySQL directory, or one the that mysql has permissions on. I bet 2 cents it will work. > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, August 13, 2002 6:52 PM > To: LR P; [EMAIL PROTECTED] > Subject: Re: l

Re: load data infile --- problem

At 22:21 + 8/13/02, LR P wrote: >thanx 4 your reply: > > >this is the error message that i got when i tried using the full pathname. > >mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member; >ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13) >mysql> % perror 13 Err

Re: load data infile --- problem

thanx 4 your reply: this is the error message that i got when i tried using the full pathname. mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member; ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13) mysql> i've tried using another user account (of course i've set a

Re: load data infile --- problem

At 2:16 + 8/13/02, LR P wrote: >hi all, > > >i have a problem with "load data..." statement. i'm using MySQL >3.23.49 from RedHat 7.3. i read Paul DuBois book about MySQL, and >tried to load data to my member table, >mysql> LOAD DATA INFILE "member.txt" INTO TABLE member; >but i didn't work.

Re: RE: load data infile

admin, Saturday, August 10, 2002, 6:31:56 AM, you wrote: a> Many of you suggested that, in regards to my problem with LOAD DATA a> [LOCAL] INFILE ... , I may have permissions problems. I checked with a> the host and the reply was, "You have access to do all commands except a> for the "grant" com

RE: load data infile

Hi Everyone, Many of you suggested that, in regards to my problem with LOAD DATA [LOCAL] INFILE ... , I may have permissions problems. I checked with the host and the reply was, "You have access to do all commands except for the "grant" command." So it would appear that I SHOULD be able to load

Re: load data

Hi. On Mon 2002-07-29 at 14:56:42 -0400, [EMAIL PROTECTED] wrote: > Hi to all, > I changed Linux from version 7.2 to 7.3 There is nothing such as Linux 7.2 or 7.3. The current stable Linux version is 2.4.18, the development version 2.5.29. What you are probably referring to is some kind of Linux

RE: LOAD DATA in LOCAL

ssage- From: Jan Peuker [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 4:02 PM To: [EMAIL PROTECTED] Subject: Re: LOAD DATA in LOCAL Hi, * I am not a professional, but I think there is no error in your config. The statement ru

Re: LOAD DATA in LOCAL

On Tuesday, 16. July 2002 08:55, [EMAIL PROTECTED] wrote: Hi, > Before posting, please check: >http://www.mysql.com/manual.php (the manual) http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html Regards Georg - Before postin

RE: LOAD DATA in LOCAL

:Re: LOAD DATA in LOCAL Hi , check this: "In MySQL 3.23.49 and MySQL 4.0.2 LOCAL will only work if you have not started mysqld with --local-infile=0 or if you have not enabled your client to support LOCAL. See section 4.2.4 Security issues with LOAD

Re: Load Data Problem

* [EMAIL PROTECTED] > Hie there, > I'm having a potential problem with Load Data Infile function > where i'm unable to get the right no. of records to appear in the table. I > have a table created in MySQL with 2 fields region (char 1)-pkey and > regionname (char 30). The table name is c

Re: Load data Input problem

At 20:35 -0700 7/2/02, Martin Scherer wrote: >I am trying to import a text file that is tab delimited. > >I am using the following , but it only returns one line. > >LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO >TABLE Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'

Re: LOAD DATA

RBRoa, Thursday, June 27, 2002, 5:07:39 AM, you wrote: R> Is it possible to use LOAD data infile syntax in MySQL ver 3.23.51 win98 R> version? Sure. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ _

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 infile and warnings

At 12:52 +0200 6/14/02, Harald Fuchs wrote: >In article , >Paul DuBois <[EMAIL PROTECTED]> writes: > >>> I imported a text file and got following results: >>> >mysql> load data local infile 'update.txt' into table PLZV lines >>> terminated by '\r\n' ignore 2

Re: load data infile and warnings

Oliver, Thursday, June 13, 2002, 5:39:52 PM, you wrote: OV> I imported a text file and got following results: OV> mysql> load data local infile 'update.txt' into table PLZV lines OV> terminated by '\r\n' ignore 2 lines; OV> Query OK, 46658 rows affected (0.66 sec) OV> Records: 46658 Deleted: 0

Re: load data infile and warnings

At 16:39 +0200 6/13/02, Oliver Vecernik wrote: >Hi, > >I imported a text file and got following results: > >mysql> load data local infile 'update.txt' into table PLZV lines >terminated by '\r\n' ignore 2 lines; >Query OK, 46658 rows affected (0.66 sec) >Records: 46658 Deleted: 0 Skipped: 0 War

Re: LOAD DATA LOCAl

THANKS IT WORKS. -Hoa >From: Bhavin Vyas <[EMAIL PROTECTED]> >To: Hoa Doan <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: Re: LOAD DATA LOCAl >Date: Sun, 09 Jun 2002 09:57:35 -0700 > >You can put it in any directory and then provide the FULL path to

Re: LOAD DATA LOCAl

You can put it in any directory and then provide the FULL path to the file in the LOAD command. Regards, Bhavin. - Original Message - From: "Hoa Doan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 09, 2002 12:26 AM Subject: Re: LOAD DATA LOCAl &g

Re: LOAD DATA LOCAl

Hi, I've created a mysql database named clients with a client table. I want to load a text file using the LOAD DATA LOCAL command, but I don't know where I have to place the text file. I know that using the LOCAL keyword the text file will be read from the client host, but in what directory?

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: Load data command?

Hi Joshua, what exactly did you try? LOAD DATA INFILE seems to be working on my box ;-) Joshua Richards wrote: > > Hi, > Could anyone please tell me how I could load a text file into a specific > column in mysql. > I tried LOAD DATA INFILE but didn't work > > Thanks, > > J.Richards > >

Re: Load data infile

Dennis, Tuesday, May 07, 2002, 10:25:25 AM, you wrote: >>I want to use the command LOAD DATA INFILE >> >>I have a table with 18 columns. But to fill the columns unfortunately I >>don't have one input file put two. >> >>The first on shall fill 16 of the 18 columns. The second one contains >>the

Re: LOAD DATA LOCAL error

Hi, Neil Bobstone wrote: >Hi, > >I Have compile Mysql 3.23.49 with : --enable-local-infile > > > >But when I want to use LOAD DATA LOCAL its says : The used command is >not allowed with this MySQL version > --enable-local-infile affects client library libmysqlclient Can you check if client l

RE: LOAD DATA LOCAL error

* Neil Bobstone > I Have compile Mysql 3.23.49 with : --enable-local-infile > > > > But when I want to use LOAD DATA LOCAL its says : The used command is > not allowed with this MySQL version There was some bugs related to --enable-local-infile in 3.23.49: http://www.mysql.com/doc/N/e/News-3

Re: load data infile problems

Daniel, Monday, April 22, 2002, 2:31:15 PM, you wrote: DJ> I'm having difficulties with loading values from a text file into my DJ> databse. DJ> I've tried the following and got these errors. last one is with full path DJ> === DJ> mysql> LOAD DATA INFILE "months.txt" INTO TABL

Re: load data infile problems

Disregard my last post.. - Original Message - From: "Daniel Jarrett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 11:44 PM Subject: Re: load data infile problems > i figured it out.. it worked when i used local. > > although

Re: load data infile problems

nual a bit cryptic dan - Original Message - From: "Melvyn Sopacua" <[EMAIL PROTECTED]> To: "Daniel Jarrett" <[EMAIL PROTECTED]> Cc: "MySQL General" <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 9:48 PM Subject: Re: load data infile problems

Re: load data infile file location???

Hey BJ, Can the mysql user actually get into that directory ('/home/user/directory')? If the mysql user can't read that directory, then it doesn't matter than it owns that file. You might want to check, do an 'su - mysql' ( replace mysql with whatever user is running the mysql daemon ), then tr

Re: load data infile file location???

Did you try load data local? That way, as I understand things, the server is not reading the data the client is. On 4/12/2002 1:26 PM, "BJ Phillips" <[EMAIL PROTECTED]> wrote: > I can load files from '/home/mysql' but when trying to do it from any other > user ('/home/user/directory'), I get a

Re: load data infile file location???

On Friday 12 April 2002 2:26 pm, BJ Phillips wrote: > I can load files from '/home/mysql' but when trying to do it from any other > user ('/home/user/directory'), I get an error 13 about cannot get stat on > file such and such. The files are located on the server and are owned by > the user, both

<    1   2   3   4   5   >