: load data help
>My question is, how can I take a log file that has 25 columns of data and
>tell mysql to only load column 1, column 3, and column 7 from the raw log
>file?
I'm not sure mysql can do this. I'd be more inclined to use cut
on a Linux system in the following fa
>My question is, how can I take a log file that has 25 columns of data and
>tell mysql to only load column 1, column 3, and column 7 from the raw log
>file?
I'm not sure mysql can do this. I'd be more inclined to use cut
on a Linux system in the following fashion:
cut -d ' ' -f 1,3,
>Thanks for the reply. I was a little confussed on the exact defintion of
>a "line", I thought it meant a whole row of data.
>The space seperated fields worked great, but still gave me the error:
>"ERROR 1054: Unknown column 'col1' in 'field list'
>I could not find anywhere on how to define the "f
I fugured out that I needed to put (name of col1, name of col2) instead of (col1,
col2).
Duhh Sorry
My question is, how can I take a log file that has 25 columns of data and tell mysql
to only load column 1, column 3, and column 7 from the raw log file?
Sorry for being so dense.
Thank
Thanks for the reply. I was a little confussed on the exact defintion of a "line", I
thought it meant a whole row of data.
The space seperated fields worked great, but still gave me the error:
"ERROR 1054: Unknown column 'col1' in 'field list'
I could not find anywhere on how to define the "field
on 03/31/2004 01:02 AM, Harald Fuchs at [EMAIL PROTECTED] wrote:
>> Where the new data to import is missing the Mname and id, so I will create
>> full complete insert statements, but how to load that in?
>
> Depending on your table structure, the following quotation from The
> F*** Manual might a
David McBride writes:
>I need to load data from a log file. The file is a space seperated
>file. I can already ignore the first 7 lines (that are commnet lines),
>but what I can not seem to do is:
>1. get load data to use the space seperated format.
>2. only load certain columns.
>
>I tried: my
THAT WORKED! Thanks - that was too easy!
Andrea
--- Kevin Carlson <[EMAIL PROTECTED]> wrote:
> Try this (untested) :
>
> update table set column=LEFT(column,
> LENGTH(column)-1)
>
>
>
> Andrea Broerman wrote:
>
> >I have successfully loaded data from a comma
> separated
> >file (CSV) into a
Try this (untested) :
update table set column=LEFT(column, LENGTH(column)-1)
Andrea Broerman wrote:
I have successfully loaded data from a comma separated
file (CSV) into a table, but the last field in each
record appears to have a little square symbol at the
end of the text which I assume is
I am running in Windows.
--- dan orlic <[EMAIL PROTECTED]> wrote:
> sounds like the difference between a windows system
> and a linux
> system. If you are doing the
> load on a linux system, a simple dos2unix
> should set you
> straight.
>
> dan
>
> Andrea Broerman wrote:
>
> >I have succes
sounds like the difference between a windows system and a linux
system. If you are doing the
load on a linux system, a simple dos2unix should set you
straight.
dan
Andrea Broerman wrote:
I have successfully loaded data from a comma separated
file (CSV) into a table, but the last field in ea
#x27;ve
created c:\my.cnf on the client BoxB and NADA! the same error.
I think it's something from the client side (BoxB) because with the same
server it works from the BoxA, but i cant figure it out!!
- Original Message -
From: "Carl Karsten" <[EMAIL PROTECT
> > > The first test i've done was on, lets say, BoxA and it worked just fine.
> > > Than, i said,'ok, lets install the client on another WKS' that is BoxB.
> And
> > > from BoxB it's not working.
> > >
> > > > > I've got 2 workstations and a server on which i have Mysql 3.23.52 -
> nt.
> > > >
> >
> Stan Sebastian <[EMAIL PROTECTED]> wrote:
> > Please help! :)
> >
> > I've got 2 workstations and a server on which i have Mysql 3.23.52 - nt.
> >
> > The clients are build in Visual FoxPro and use MyODBC for connecting to
> > server.
> >
> > From both WKS statements like select, insert, update,
Stan Sebastian <[EMAIL PROTECTED]> wrote:
> Please help! :)
>
> I've got 2 workstations and a server on which i have Mysql 3.23.52 - nt.
>
> The clients are build in Visual FoxPro and use MyODBC for connecting to
> server.
>
> From both WKS statements like select, insert, update, delete work jus
;>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/2/04, 1:29:59 PM, Mark Riehl <[EMAIL PROTECTED]>
wrote regarding RE: Load Data and Timestamps:
> Sorry for the confusion, maybe I wasn't clear in the question.
rather a skid in broadside, thoroughly used, totally worn, and
loudly proclaiming: "WOW! What a ride!"
-Original Message-
From: Mark Riehl [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 1:30 PM
To: [EMAIL PROTECTED]
Subject: RE: Load Data and Timestamps
Sorry for the
Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 02, 2004 2:17 PM
To: Mark Riehl
Cc: [EMAIL PROTECTED]
Subject: Re: Load Data and Timestamps
An invalid datetime, or in your case, an empty value, will be set to the
nearest zero value representation.
>>&g
An invalid datetime, or in your case, an empty value, will be set to the
nearest zero value representation.
>> Original Message <<
On 3/2/04, 1:06:50 PM, Mark Riehl <[EMAIL PROTECTED]>
wrote regarding Load Data and Timestamps:
> All - I'm running MySQL 4.0.13 u
On Thu, 15 Jan 2004, Jamie Murray wrote:
> Hi Guys,
> after waiting about a minute I get
>
> ERROR 2013 (HY000): Lost connection to MySQL server during query
>
See if changing any of the
SHOW VARIABLES LIKE 'net%timeout';
helps.
Not sure why the crash popup comes up, however.
cheers,
Tobias
--
You have to use Load Data Local. See this section of the manual:
http://www.mysql.com/doc/en/LOAD_DATA.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Both your client and your server must have the local flag turned on. Check phpMyAdmin
to see if there is an option to turn this on for the client side. I use ADO/ODBC and I
have to create a my.cnf file on the client machine with local infile=1(ON) in the
[client] section and tell the ODBC drive
In the last episode (Dec 20), ads mysql said:
> Hi,
> I was looking to solution of same problem as Hans
> Kind.
>
> You have suggested to map network drive. Is it O.K.if SAMBA is
> ruuning on main server. Or can you guide to Documentation for mapping
> on Linux. I know it is out of topic but it wi
Hi,
I was looking to solution of same problem as Hans
Kind.
You have suggested to map network drive. Is it O.K.if
SAMBA is ruuning on main server. Or can you guide to
Documentation for mapping on Linux.
I know it is out of topic but it will help me great.
Thanks
--- Larry Brown <[EMAIL PROTECTE
If the servers are on the same local subnet, why not just map a network
drive so both servers have access to the file locally.
-Original Message-
From: Hans Kind [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 8:22 AM
To: [EMAIL PROTECTED]
Subject: load data in file
Hi,
We h
That is brilliant thank you. I was doing it the wrong way
around when i was naming the fields.
Thank you for your help
graham
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 14:46
To: Graham Little
Cc: '[EMAIL PROTECTED]'
Subject: Re:
On Mon, 15 Dec 2003, Graham Little wrote:
doing selective quoting below.
> LOAD DATA INFILE "D:\mysql\sql\CountryData.txt"
> INTO TABLE cou (id, country);
See how you try to load from a file into the columns id and country in the
cou table?
> The table the data is being inserted int
on 15/12/03 12:13 pm, Graham Little at [EMAIL PROTECTED]
wrote:
>
> +--+-+--+-+-+---+
> | Field| Type| Null | Key | Default | Extra |
> +--+-+--+-+-+---+
> | cou_id | int(11) | | PRI | 0 | |
> | cou
Graham Little <[EMAIL PROTECTED]> wrote:
>
> I am currently trying to run the following command:
>
>LOAD DATA INFILE "D:\mysql\sql\CountryData.txt"
>INTO TABLE cou
>FIELDS TERMINATED BY ','
>LINES TERMINATED BY '\r\n'
>(id, country);
>
> Example data in f
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
[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
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
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
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
"Curley, Thomas" <[EMAIL PROTECTED]> wrote:
>
> Platform RH linux on Dell with MySql 4
>
> I changes the directory to where the data file was picked up from to a sy=
> mbolic link and now get the error
>
> Can't get stat of '/home/test/data_in/TEST.TXT' (Errcode: 13)
>
> So all I did was to cha
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
"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
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
"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
Are you placing the file in the same directory as the MySQL data files? Are
the databases and the location you placed the text file on the same physical
drive?
-Original Message-
From: Hans Kind [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 7:22 AM
To: [EMAIL PROTECTED]
Subje
LOAD DATA LOCAL INFILE
But it must be enabled on both the server and client.
See the docs.
Hans Kind wrote:
Hi,
We have a 2 server setup. 1 server runs the web server with a PHP
application, the second server is the mysql database server.
The php application needs to connect to the mysql server
Thanks for the reply Kim!
On Tuesday 18 November 2003 12:47 pm, you wrote:
> Hello Robert ,,
>
> I have no explanation , just a dummy question ,
> 1) Are all values u try to put into column 5 a float with . ?
Always floats.
> 2) what if u try with integer ?? without . ?
haven't yet tried.
>
Hello Robert ,,
I have no explanation , just a dummy question ,
1) Are all values u try to put into column 5 a float with . ?
2) what if u try with integer ?? without . ?
3) can u input float values in column 3 ?
4) are u running mysqlcc from same pc ?
5 could it be some settings with decimal p
have you verified that the number of columns match? That the data types are
matching as well?
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:01 PM
To: [EMAIL PROTECTED]
Subject: LOAD DATA ?
Hello,
My Load data command seems not to load data
> But myisam_sort_buffer is, AFAIK, only used during "Repair by sort"
> (in PROCESSLIST), not "Repair with keycache." What did yours say
> during the 21 hours? It may change from sort to keycache after awhile
> -- something to do with the size of the indexes or something. Not
> exactly sure about t
- Original Message -
From: "Eric Jain"
To: "mysql-general" <[EMAIL PROTECTED]>
Sent: Wednesday, November 05, 2003 5:11 AM
Subject: Re: LOAD DATA hangs
> > 4) ALTER TABLE ENABLE KEYS -> Puts a full load on the CPU, but
neither
> > index nor table
> 4) ALTER TABLE ENABLE KEYS -> Puts a full load on the CPU, but neither
> index nor table size seem to change, even after waiting for an hour.
> Based on smaller data sets, I'd expect the index to reach something
> close to 4 GB.
Update: After several hours, the index file started growing, althou
> Any idea what has gone wrong here? Yet another limitation I have run
> into?
Tried this:
1) CREATE TABLE
2) ALTER TABLE DISABLE KEYS
3) LOAD DATA -> Complete after 30 min, table size 5.78 GB, index size
1.21 GB.
4) ALTER TABLE ENABLE KEYS -> Puts a full load on the CPU, but neither
index nor ta
Victoria Reznichenko wrote:
[EMAIL PROTECTED] wrote:
mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
TABLE quantis_mkr;
Query OK, 271392 rows affected (4 min 2.95 sec)
Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
How can I see those warnings?
I checked the error log but not
[EMAIL PROTECTED] wrote:
>> > mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
>> TABLE quantis_mkr;
>> > Query OK, 271392 rows affected (4 min 2.95 sec)
>> > Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
>> >
>> > How can I see those warnings?
>> > I checked the error log but
> > mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO
> TABLE quantis_mkr;
> > Query OK, 271392 rows affected (4 min 2.95 sec)
> > Records: 271392 Deleted: 0 Skipped: 0 Warnings: 61
> >
> > How can I see those warnings?
> > I checked the error log but nothing shows up there.
> >
>
On 26-Oct-2003 Heinrich Stoellinger wrote:
> I have a small dBase4 Database that contains 260 records. Exporting it
> to a text file and then using LOAD DATA into table... I see that of the
> 260 records only 204 get loaded. I cannot make out what is specific
> about the records skipped. I do g
"Tuncay Baskan (Yaz.Muh.-Proje Gel.ve Uyg.Gr.)" <[EMAIL PROTECTED]> wrote:
> When I run LOAD DATA it sometimes notices that there were some warnings. For example;
>
> mysql> LOAD DATA LOCAL INFILE './2003-01/MKR_OCAK.txt' INTO TABLE quantis_mkr;
> Query OK, 271392 rows affected (4 min 2.95 sec)
>
Hi Kabbouri
Please see below, an excerpt from the MySQL manual, that answers your
question.
If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty
(''), a
fixed-row (non-delimited) format is used. With fixed-row format, no
delimiters are used
between fields (but you can still
Wolfgang -
> I have a text file with 120'000 lines. When I do a
> load data local infile
> only 85'416 records are loaded. There is no message of the sort
> Query OK, X rows affected
> just the next prompt is displayed.
>
> I'll be glad for any hint what could cause this behavior.
[EMAIL PROTECTED] wrote:
In MYSQL documentation the following line is
Some cases are not supported by LOAD DATA INFILE:
1. Fixed-size rows( FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty)
and BLOB or TEXT columns
I defined a column in a table as type TEXT. I then loaded values using LOA
Sill
Cc: [EMAIL PROTECTED]
Subject: Re: Load data: odd behaviour
How did you determine this?
I hope not by the order returned when you select them.
There is no order to the set returned unless you use an ORDER BY clause.
Adrian Sill wrote:
>Morning all,
>
>I've been using the same f
How did you determine this?
I hope not by the order returned when you select them.
There is no order to the set returned unless you use an ORDER BY clause.
Adrian Sill wrote:
Morning all,
I've been using the same format of text files to import monthly text
files using LOAD DATA LOCAL INFILE into
Bill Leonard <[EMAIL PROTECTED]> wrote:
> Thank you for the response Victor!
Victoria ;)
>
> On 9/22/03 4:02 AM, "Victoria Reznichenko" <[EMAIL PROTECTED]>
> wrote:
>
>>> One of our users is trying to execute the LOAD DATA INFILE command (using
>>> PHP to talk to MySQL). It is failing for some
Thank you for the response Victor!
On 9/22/03 4:02 AM, "Victoria Reznichenko" <[EMAIL PROTECTED]>
wrote:
>> One of our users is trying to execute the LOAD DATA INFILE command (using
>> PHP to talk to MySQL). It is failing for some reason... Everything I believe
>> is set properly, i.e:
>>
>> - t
Bill Leonard <[EMAIL PROTECTED]> wrote:
> Let me preface this by saying I am not a MySQL guru myself, but more of a
> general sys admin... !
>
> One of our users is trying to execute the LOAD DATA INFILE command (using
> PHP to talk to MySQL). It is failing for some reason... Everything I believe
The only thing I would suggest is to look in the mysqllog and look at the
command that is specifically being issued, and then try it from the mysql
command line interface, and see if it works there, it should give you a good
enough reason if it doesn't, and if it does, it more than likely is some
Copy the db from the master to the slave.
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
-->-Original Message-
-->From: Aris Santillan [mailto:[EMAIL PROTECTED]
-->Sent: Friday, September 19, 2003 3:10 AM
-->To: [EMA
"Aris Santillan" <[EMAIL PROTECTED]> wrote:
>
> load data from master doesnt work on mysql 3.23.52 version
>
>
> how can i solve this?
You can use mysqldump program or archive master's data dir. Here you can find more
info:
http://www.mysql.com/doc/en/Replication_HOWTO.html
--
For
Well I figured out what was going on, MS uses a LF,CR instead of just a Line
feed. The was corrupting the first column. I added a LINES TERMINATED BY
statement and put in the '\r\n'. Now everything works fine.
Thanks again.
- Original Message -
From: "upscope" <[EMAIL PROTECTED]>
To: "MySq
.. Thanks again!!
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 1:55 PM
To: [EMAIL PROTECTED]
Cc: Montagna, Dan
Subject: RE: Load data infile issue
On 5 Aug 2003 at 11:16, "Montagna,Dan" <[EMAIL PROTECTED]> wrote:
> Thanks
ot; the load local file option?
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 10:53 AM
To: '[EMAIL PROTECTED]'
Cc: Montagna, Dan
Subject: Re: Load data infile issue
On 5 Aug 2003 at 9:37, Montagna, Dan wrote:
> $result = mysql_db_
I'm using some default table names and such here...my actual code has the
appropriate table, server, un, pw etc...
On 5 Aug 2003 at 11:16, "Montagna,Dan" <[EMAIL PROTECTED]> wrote:
> Thanks Keith, that got me past the first two queries but I'm now
> getting an " Invalid DATA LOAD query" . Someone told me that the
> "load data infile option is not always on by default. Is there a
> piece of code I need to in
On 5 Aug 2003 at 9:37, Montagna, Dan wrote:
> $result = mysql_db_query('$sql_id',"DELETE FROM tablename") or die
> ("Invalid DELETE query");
It's helpful to print mysql_error() when you have an error, so you
get a message more specific than "Invalid DELETE query". In this
case, you're trying t
I'm using some default table names and such here...my actual code has the
appropriate table, server, un, pw etc...
Montagna, Dan wrote:
Hello,
I'm a very new mysql/php user and am trying to use the load data infile
command without luck. I'd like to replace a table using a text file but
can't get it to work. I set up a test table with no records using a telnet
console. I'm trying to write a php page that ta
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
I've found the rpm.
fab a écrit :
Hi and thanx :)
I've found dbf2mysql and it should solve my prob.
However, my linux server is a production server (web + mail) and none
programmation environnement is installed on it (no gcc and so on) and i
don't want to.
So, could anyone send me the binary f
Hi and thanx :)
I've found dbf2mysql and it should solve my prob.
However, my linux server is a production server (web + mail) and none
programmation environnement is installed on it (no gcc and so on) and i
don't want to.
So, could anyone send me the binary for dbf2mysql ?
I use Red-Hat 7.3 on
1 will work.
2 will not work.
3 Use dbf2mysql. ( It should be in the downloads section on mysql.com )
fab wrote:
Hi all,
I'm quite new in mysql. Despite i've read a part of the doc, i can't
fix my prob. Here is my question:
I want to convert a DBASE IV file into mysql table:
1) Have i to convert
If the ID field is *not in your text file, why not take it out of the
CREATE statement and add it afterwards?
Ted
On Thursday, June 26, 2003, at 10:46 PM, Scott Haneda wrote:
I have this
CREATE TABLE `dictionary` (
`id` int(11) NOT NULL auto_increment,
`word` text NOT NULL,
`def` text N
By default, "LOAD DATA INFILE ..." is disabled (I am not sure from which
version). You may need to compile MySQL with -enable-local-infile". You
may find details on www.mysql.com .
Ruth
- Original Message -
From: "mysql" <[EMAIL PROTECTED]>
To: "mySQL List" <[EMAIL PROTECTED]>
Sent: Tue
I ran into this too. I assume it is a limitation on the free version of MySQL, and
that
you have to pay to use "load data" in an SQL script. To import my data files, I use
the "mysqlimport" function from the command line or batch file. It seems to support
most of the "load data" options.
-
You will have to write a program to read your text files and
insert/update the appropriate records.
Fernando Gerent wrote:
Hi everybody,
I need to use the Load Data Infile to insert different columns from different files in
a table, but I can't figure out how to keep the number of rows, like
f
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
).
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
-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.
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
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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jerome Smith wrote:
> Hello everybody,
>
> Im new to this list, and also new to MySQL. I would be very grateful if
> someone could help me with the following problem:
>
> I have MySQL server version 4.0.12 with a database on a Linux server. I
> work
Another problem with load data and replication? I've identified 2 confirmed
bugs in the last 2 releases. Honestly, I've pretty much given up on using
load data on my master server for the time being. I'm now using scripts that
generate extended insert statements instead.
--jeff
- Original Mes
-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
On Tuesday 25 March 2003 19:54, Salada Duncan wrote:
> I was able to work around the problem by giving "insert" privileges to the
> user for the WHOLE database. This is definitely not optimal because I only
> wish this user to be able to insert into one table in the database. But as
> soon as I
ge-
From: Salada, Duncan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 11:08 AM
To: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Subject: RE: load data infile question
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 200
-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
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 the user to be able to use "l
On Sunday 23 March 2003 21:04, Klaus Mueller wrote:
> LOAD DATA LOCAL INFILE "member.txt" INTO TABLE member;
> -> ERROR 1148: the used command is not allowed with this MySQL version
> Does anybody know how to manage these two commands in MySQL 3.23.49?
Add --local-infile=0 to mysqld commandline.
What's the error you're getting? What OS are you running on? If it's *nix,
make sure the file you are trying to load, and the full path to that file,
is readable by the user mysql runs as. I once had some files in a user's
home directory I was trying to load and although the file was
world-readable
At 19:58 +0300 3/14/03, [EMAIL PROTECTED] wrote:
I have strange problem with LOAD DATA INFILE
$file="base.txt";
$conn=mysql_connect('localhost', 'user', 'paswd');
mysql_select_db('realestate', $conn);
$query="LOAD DATA INFILE '".$file."' REPLACE INTO TABLE
table_name FIELDS TERMINATED BY '\t' LINE
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/National1-subse
On Thursday 20 February 2003 14:40, Andy De Petter wrote:
> When I try to perform a LOAD DATA INTO, I get a "Permission Denied"
> problem, although I (should) have the correct privileges, for a specific
> user:
>
>
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO
> 'myuse
;
To: "Jerry" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 1:00 PM
Subject: Re: LOAD DATA INTO not working
>
> I've just tried, and it seems to work This means, there is an error
> in the O'Reilly book (July 1999, 1st Edit
he FILE privilege on the server host. "
>
> http://www.mysql.com/doc/en/LOAD_DATA.html
>
> Did adding FILE to the permissions do it ?
>
> Jerry
>
> - Original Message -
> From: "Andy De Petter" <[EMAIL PROTECTED]>
> To: "Jerry"
201 - 300 of 476 matches
Mail list logo