re: Re: Fw: Load data infile & replication - 3.23.56

On Thursday 27 March 2003 14:22, Sohail Hasan wrote: > I am running mysql 4.0.12 on both the master and slave servers. I am > facing the same problem with a slight variation. When I am trying to > import my database dump on the master the replication fails and slave > thread exits with the followi

Re: Fw: Load data infile & replication - 3.23.56

3.dmp.gz mycms.cnf Sincerely, Sohail Alexander Keremidarski wrote: Jeff, Jeff Kilbride wrote: Subject: BUG: Load data infile & replication - 3.23.56 Replication doesn't seem to be replicating LOAD DATA INFILE correctly in 3.23.56. Starting with a master and slave that were in sync

RE: RE: load data infile question

-Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 6:55 AM To: [EMAIL PROTECTED] Subject: re: RE: load data infile question Hi! >On Tuesday 25 March 2003 19:54, Salada Duncan wrote: > >> I was able to work around the probl

re: RE: load data infile question

But as > soon as I gave the user insert privileges for the whole database the "load > data infile" command worked. This seems like a bug to me, perhaps it has > been dealt with in newer versions though. It works fine for me on 3.23.56. Could you upgrade MySQL server and tes

Re[2]: BUG: Load data infile & replication - 3.23.56

Jeremy, >> Also, is there any way to find out what records were skipped and >> why? > Nope. Not yet. I think that's coming in 4.1? Yes and no: http://www.mysql.com/doc/en/SHOW_WARNINGS.html "The MySQL server sends back the total number of warnings and errors you got for the last command." My

Re: BUG: Load data infile & replication - 3.23.56

On Tue, Mar 25, 2003 at 11:05:06PM -0800, Jeff Kilbride wrote: > Replication doesn't seem to be replicating LOAD DATA INFILE correctly in > 3.23.56. Starting with a master and slave that were in sync, I imported a > file: [snip] > Notice that the slave doesn't skip the r

BUG: Load data infile & replication - 3.23.56

Replication doesn't seem to be replicating LOAD DATA INFILE correctly in 3.23.56. Starting with a master and slave that were in sync, I imported a file: --- MASTER mysql> select count(*) from list where sourceID=0; +--+ | count(*) | +--+ |

RE: load data infile question

es for the whole database the "load data infile" command worked. This seems like a bug to me, perhaps it has been dealt with in newer versions though. Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Messa

RE: load data infile question

-Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 9:06 AM To: [EMAIL PROTECTED] Subject: re: load data infile question Hi! On Friday 21 March 2003 20:41, Salada Duncan wrote: >> I am using MySQL 3.23.49 and have started ha

re: load data infile question

On Friday 21 March 2003 20:41, Salada Duncan wrote: > I am using MySQL 3.23.49 and have started having a problem with the "load > data infile" command. > > I recently created a new user with select,insert,update,and delete on one > table only (tableA). Because I want t

Re: load data infile question

h the file was world-readable, the directory permissions restricted access. --jeff - Original Message - From: "Salada, Duncan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 21, 2003 10:41 AM Subject: load data infile question > Hi everyone, > >

load data infile question

Hi everyone, I am using MySQL 3.23.49 and have started having a problem with the "load data infile" command. I recently created a new user with select,insert,update,and delete on one table only (tableA). Because I want the user to be able to use "load data infile" to load re

Re: Can't load data infile ...says :" ...(Using password: YES)"

off this feature to get a quicker startup with -A Database changed but when I type : load data infile '/user's_path/datafile' into table database's_table fields terminated by ',' (field_1,field_2,field_3,field_4); I returns: ERROR 1045: Access denied for user: '[E

Can't load data infile ...says :" ...(Using password: YES)"

Database changed but when I type : load data infile '/user's_path/datafile' into table database's_table fields terminated by ',' (field_1,field_2,field_3,field_4); I returns: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]

Re: Load data infile warnings?!?! STILL not in 4.1?

At 19:08 -0500 2/27/03, [EMAIL PROTECTED] wrote: After wrestling to get everything set up with 4.1, it looks like it still does not give the VITAL information of what problems were encountered in data loads (on 4.1 2/25/03) - mysql> load data infile '/Users/jason/Desktop/Hoodata/N

Load data infile warnings?!?! STILL not in 4.1?

After wrestling to get everything set up with 4.1, it looks like it still does not give the VITAL information of what problems were encountered in data loads (on 4.1 2/25/03) - mysql> load data infile '/Users/jason/Desktop/Hoodata/National1-subset.tab' into table tri; Query O

Re: BUG? 3.23.55 not replicating LOAD DATA INFILE

3.23, > since it makes all the replicate_* config commands useless. Yes, if someone uses LOAD DATA INFILE. There are very good chances that this bugfix will go in 3.23. But I cannot state it because I'm not alone in the decision process. > Was this > introduced recently? No, I hav

Re: BUG? 3.23.55 not replicating LOAD DATA INFILE

20, 2003 1:06 PM Subject: Re: BUG? 3.23.55 not replicating LOAD DATA INFILE > Hi > > Thanks for your bug report. > In latest 3.23 and 4.0, the slave ignores any LOAD DATA INFILE > as long as one of these options is set on the slave : > > replicate_do_table > replicate_wi

Re: BUG? 3.23.55 not replicating LOAD DATA INFILE

Hi Thanks for your bug report. In latest 3.23 and 4.0, the slave ignores any LOAD DATA INFILE as long as one of these options is set on the slave : replicate_do_table replicate_wild_do_table replicate_ignore_table replicate_wild_ignore_table regardless of the values of these options, which is a

Re: BUG? 3.23.55 not replicating LOAD DATA INFILE

]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 5:32 AM Subject: re: BUG? 3.23.55 not replicating LOAD DATA INFILE > Jeff, Egor, > > Guilhem Bichot just found a bug in replication of LOAD DATA LOCAL INFILE in > 4.0. > > Th

re: BUG? 3.23.55 not replicating LOAD DATA INFILE

selective replication of some tables or databases? If yes, check also that your LOAD DATA INFILE is not excluded by these rules. Regards, Heikki Innobase Oy sql query . Subject: re: BUG? 3.23.55 not replicating LOAD DATA INFILE From: Egor Egorov Date: Thu, 20 Feb 2003 14:07:02 +0200

re: BUG? 3.23.55 not replicating LOAD DATA INFILE

On Thursday 20 February 2003 01:04, Jeff Kilbride wrote: > I have one master and two slaves all running 3.23.55-max on RedHat 7.3. > I've had replication up and running smoothly for several days. Today, I > decided to try out LOAD DATA INFILE on the master. After successfully &g

BUG? 3.23.55 not replicating LOAD DATA INFILE

I have one master and two slaves all running 3.23.55-max on RedHat 7.3. I've had replication up and running smoothly for several days. Today, I decided to try out LOAD DATA INFILE on the master. After successfully loading on the master, I checked both slaves and neither one had the new data.

RE: Re: Load Data Infile problem.

Para: [EMAIL PROTECTED] Asunto: 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

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

Load Data Infile problem.

Hi List. I have been working on a problem that is driving me crazy. I have to create a process in which I upload some info to a table. Since I have to add some different information to that table, I decided to do it like this. 1.I create a temporary table copying the structure of my final table.

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

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 y

fyi LOAD DATA INFILE crashes Linux

I have a Red Hat 7.2 box running MySQL 3.23 on an Athlon XP 1700 with 1 GB of RAM. I have had this box for months and it has never had a problem. Yesterday I invoked a LOAD DATA LOCAL INFILE command on a text file with 1.5M 2-field tab-delimited varchars into an empty 2-field table and it not only

re: now() function not working with load data infile

[EMAIL PROTECTED] cc: Subject:re: now() function not working with load data infile On Tuesday 24 December 2002 10:30, [EMAIL PROTECTED] wrote: > I've created a test table with two columns. The first > one is a varchar type for inputting first names. The > second column is dat

re: now() function not working with load data infile

t > interested in getting that to work at this time. > > If I use MySQL monitor, I can use the now() function > to insert the current date/time into the datetime > column. > > When using load data infile, only the varchar column > shows a value, but the datetime column shows

now() function not working with load data infile

n use the now() function to insert the current date/time into the datetime column. When using load data infile, only the varchar column shows a value, but the datetime column shows a string of zeros. I don't understand why using MySQL monitor works for now() function, but I can't repr

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 impo

Load data infile...

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 DB using load data infile. However, when i do a "select * " on that table which i've just importe

re: sql query LOAD DATA INFILE question

for the next burst of files, I want to > insert these into the tables, then erase the files. > Normally LOAD DATA INFILE LOCAL works fine here. The problem is that > the machine holding these tables is a different one. > The question is, is it possible to run LOAD

sql query LOAD DATA INFILE question

into the tables, then erase the files. Normally LOAD DATA INFILE LOCAL works fine here. The problem is that the machine holding these tables is a different one. The question is, is it possible to run LOAD DATA INFILE to do the inserts on the remote machine, or is it better to

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 Sub

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 instru

re: zeros in TIMESTAMP column when using LOAD DATA INFILE

miked2miked, Wednesday, December 04, 2002, 8:18:04 AM, you wrote: myc> I looked at the MySQL manual and it tells you how to myc> do automatic timestamps in TIMESTAMP columns. I can myc> do that fine if I use INSERT or UPDATE statements from myc> MySQL monitor. However, LOAD DATA INF

zeros in TIMESTAMP column when using LOAD DATA INFILE

I looked at the MySQL manual and it tells you how to do automatic timestamps in TIMESTAMP columns. I can do that fine if I use INSERT or UPDATE statements from MySQL monitor. However, LOAD DATA INFILE delivers zeros in the TIMESTAMP column. What am I overlooking? How can I avoid getting the

character set conversion and LOAD DATA INFILE

I reconfigured and recompiled MySQL 3.23.53 that is supports now conversion between Windows-1250 and ISO-8859-2 charsets. If I do 'set character set cp1250_latin2' in a session, then everything goes all right BUT only in insert/update/select statements. If I do the same set and use

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 CH-8

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/

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_ad

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

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 DuBoi

Re: load data infile syntax

BY. I think there's something else wrong with the statement. You do need to use two backslashes to specify an escape character of a single backslash. Can we see the entire LOAD DATA statement exactly as you specified it originally? At 10:43 PM 11/5/2002 -0600, you wrote: At 14:38 -050

Re: load data infile syntax

" away and shift 1 byte left. My data will mass up. That is why I still need "\" I posted my syntax before, but nobody helped me to figure out. So this time I did my test again and found out only need one "\" for ESCAPED BY. At 10:43 PM 11/5/2002 -0600, you wrote: At

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?

load data infile syntax

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 '\'] - Before posting, please check: http://www.mysql.c

Re: Replication and LOAD DATA INFILE

> Lothar Jenisch wrote: > > >Hello, > > > >I have a problem with replication and LOAD DATA INFILE. > >I use version 3.23.37 on Liunx distribution. > > > >1. I check the replication with a manual i.e. insert and > > delete of one record

Re: Replication and LOAD DATA INFILE

Lothar Jenisch wrote: >Hello, > >I have a problem with replication and LOAD DATA INFILE. >I use version 3.23.37 on Liunx distribution. > >1. I check the replication with a manual i.e. insert and > delete of one record. This works fine without problems. >2. I do

Replication and LOAD DATA INFILE

Hello, I have a problem with replication and LOAD DATA INFILE. I use version 3.23.37 on Liunx distribution. 1. I check the replication with a manual i.e. insert and delete of one record. This works fine without problems. 2. I do a LOAD DATA INFILE 'file.txt' REPLACE INTO T

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 du

Re: LOAD DATA INFILE problem

ump: > > mysql> DROP TABLE IF EXISTS testthis; > Query OK, 0 rows affected (0.16 sec) > > mysql> CREATE TABLE testthis(ID INT DEFAULT '0',Reviews CHAR (50),Date > DATE,Bookmark CHAR (50), > -> Title CHAR (90),Web_Page CHAR (50)); > Query OK, 0 rows aff

LOAD DATA INFILE problem

REATE TABLE testthis(ID INT DEFAULT '0',Reviews CHAR (50),Date DATE,Bookmark CHAR (50), -> Title CHAR (90),Web_Page CHAR (50)); Query OK, 0 rows affected (0.16 sec) mysql> LOAD DATA INFILE "/home/http/run/isak/wmj-new/uploaded/testthis.txt" INTO TABLE testthis; ERROR

re: LOAD DATA INFILE problem

t; DROP TABLE IF EXISTS testthis; TJ> Query OK, 0 rows affected (0.16 sec) TJ> mysql> CREATE TABLE testthis(ID INT DEFAULT '0',Reviews CHAR (50),Date DATE,Bookmark CHAR (50), TJ> -> Title CHAR (90),Web_Page CHAR (50)); TJ> Query OK, 0 rows affected (0.16 sec) TJ>

problems with load data infile: wrong bytesec

s are written in root[csh]@amber1[17]# perl -v This is perl, v5.6.1 built for sun4-solaris-64int Using DBD::mysql. As suggested at http://www.mysql.com/doc/en/Insert_speed.html I am using load data infile on a table with indexes turned off. My loading script croaks with two different errors. I h

Re: Error with LOAD DATA INFILE

check the permissions of the enclosing directory - hcir On Monday, Oct 7, 2002, at 17:43 America/Anchorage, Unidux (MIS) - K Sudhir wrote: > Hi, > > When i try to query ... load data infile ... > i am getting the following error ... > ERROR 13: Can't get stat of '

Error with LOAD DATA INFILE

Hi, When i try to query ... load data infile ... i am getting the following error ... ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Errcode: 2) The above mentioned same query i have used in many other modules, but i never get the error. The file from which i am try

RE : How to see warning messages for load data infile

just replace all , with . in my CSV file with Ultraedit. Greetings, JM -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: re: How to see warning messages for load data infile David, Saturday, September 28,

re: How to see warning messages for load data infile

David, Saturday, September 28, 2002, 2:37:00 AM, you wrote: DY> Hi all. I'm trying to load a file into mysql using "load data infile" and DY> got a ton of warnings. Is there any way to see what the warnings are? MySQL doesn't store warnings anywhere. -- For t

How to see warning messages for load data infile

Hi all. I'm trying to load a file into mysql using "load data infile" and got a ton of warnings. Is there any way to see what the warnings are? Thanks. David - Before posting, please check: http://www.mysql

Problem with symlinked files used with load data infile

all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: --help Subject: Problem with symlinked files used with load data infile >Description: When I give an absolute path of a file as argument to LOAD DATA INFILE I get an errcode: 13 ( Can't get

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

Re: Load Data Infile

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, 20 Aug 2002 21:31:45 +0100 > "DL Neil&qu

Re: Load Data Infile

d data >to do this automaticaly? > > Serge. > > On Tue, 20 Aug 2002 21:31:45 +0100 > "DL Neil" <[EMAIL PROTECTED]> wrote: > > > Hello Serge, > > > > > I am having troubles with Load Data Infile and cannot figure out the > > problem.

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

Serge. On Tue, 20 Aug 2002 21:31:45 +0100 "DL Neil" <[EMAIL PROTECTED]> wrote: > 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 > mys

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 th

Load Data Infile

Hello, 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

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/me

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 anot

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 "membe

load data infile --- problem

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. i'

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

Load Data infile problem

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'; Why would it do

Load data infile problem

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'; Why would it do

Re: file size limit hitting when "LOAD DATA INFILE"

day, June 24, 2002 7:23 PM Subject: file size limit hitting when "LOAD DATA INFILE" > Hi, all: > I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD > DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) > reports "Lost con

file size limit hitting when "LOAD DATA INFILE"

Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) reports "Lost connection to MySQL server during query". How can I clearly know the failed reason is just hit th

file size limit hitting when "LOAD DATA INFILE"

Hi, all: I use MySQL 3.23.47, RH linux 7.2, file size limit is 4G. When "LOAD DATA INFILE" to a table whose file size is 4G, it fails and mysql_error(...) reports "Lost connection to MySQL server during query". How can I clearly know the failed reason is just hit th

Re: Problem with load data infile and user's privileges

On Sat, 15 Jun 2002, Sergey Bondar wrote: > OS Linux Red Hat 7.2 > MySql 3.23.41 > > Hi All! > That is my steps. > > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK The user needs the file privilege. Granting all on mydb.* does not giv

Problem with load data infile and user's privileges

col01 CHAR(2), col02 CHAR(2)); I got: OK Then I doing: LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01; I got: ERROR 1045 Access denied fot user: 'client@localhost' (Using password: YES) Also I changed manualy for user(client) in database mysql in tables user & db f

Re: Problem with load data infile and user's privileges

>I doing: >mysql -u client -p >passwd >CREATE DATABASE mydb; >I got: >OK > >CREATE TABLE mytable ( col01 CHAR(2), col02 CHAR(2)); >I got: >OK > >Then I doing: >LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01; >I got: >ERROR 1045 Access

Re: Problem with load data infile and user's privileges

On Fri, 14 Jun 2002, Sergey wrote: > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK > > > Then I doing: > LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01; > I got: >

Problem with load data infile and user's privileges

col01 CHAR(2), col02 CHAR(2)); I got: OK Then I doing: LOAD DATA INFILE "/usr/data/myfile" INTO TABLE tab01; I got: ERROR 1045 Access denied fot user: 'client@localhost' (Using password: YES) Also I changed manualy for user(client) in database mysql in tables user & db fr

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

load data infile and warnings

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 Warnings: 4 Where are the warnings stored? Can I find out

load data infile

Hi, I'm running the following query: Load data infile 'data.txt' into table records fields terminated by ';' IGNORE 1 LINES The field-order in my txt file is different than that in my table, can i rearrange the order of the data being loaded and load blank fields in b

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 1

Load data infile

sql, query > >Hello Dear Group > > >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

RE: [MySQL] Access denied on LOAD DATA INFILE statement - no subject provided with posting

Amit, Perhaps try running your LOAD DATA INFILE statement typed at the command prompt of the mysql client, and maybe you will get more info as to what the problem is. You may have a MySQL installation where the 'LOAD DATA INFILE' statement is not permitted by default.

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 D

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

<    1   2   3   4   5   6   >