Hi,
I wanted to ask some more experienced mysql users to give me some advice on
a project I am currently planning.
I have a text file with three columns: strName(char6), position(integer),
str(char36)
This file has some 3 billion rows (3,000,000,000). There are some "str"s
that are duplicate
I'm new to bin-logging and replication. I have a database, about 3GB that I
have been converting data off of an old system into this new one. The basic
procedure is to take the database offline at 10PM once a week, export the
entire DB as an SQL file using mysqldump then download and import it into
Ok.. Disregard... the spaces I added for troubleshooting after the
commas fubar'd it.
I have a script that builds a data file. The data looks like this:
"62527427012682984", "191151", "177628526", "3634025281", "1", "58400",
"80", "1899", "", "2006/10/02 23:15:02", "19",
"47","","2006-11-02-231557-cust.txt", "0", "0", "IKE", "ESP: AES-256 +
SHA1", "cx-ccb_vpn", "Cx-CCB", "", ""
"62
Well that's good to know. This is a InnoDB engine db. I did try specifying
the how the fields and lines in the file are terminated to the LOAD DATA
INFILE program but I still get the same error message.
Still have no idea what I'm doing wrong. I was getting errors where the
program was complainin
Ferindo -
I believe there is a 64K limit on the length of a record in a MyISAM
table (text and binary columns excluded), but I haven't ever seen a
number of columns limit. Based on your table description below I don't
think you're close to such a problem.
Based on the error you receive (no
Does MySQL have any constraints when it comes to the number columns that it
can accurately support/import in any one table/file. When I see this file
that is failing to get properly read into the database, that's what comes to
mind... It's failing because of some kind of constraint or threshold of
I guess my general reason for posting this was to ask: "Are there any known
issues with the LOAD DATA INFILE comand in MySQL?" However, I stripped all
the data in the file (test.tab) down to one record which still wouldn't
load. Here is the command:
mysql> LOAD DATA INFILE 'C:/Program Files/Apach
Ferindo Middleton wrote:
I'm trying to load data into a table from a file but I get an error
message:
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
This error message isn't very specific as to what is going wrong and I have
no idea what it is about the data file that
I'm trying to load data into a table from a file but I get an error message:
ERROR 1329 (02000): No data - zero rows fetched, selected, or processed
This error message isn't very specific as to what is going wrong and I have
no idea what it is about the data file that is wrong. Of course, I know
>Now, I have another problem:
>ERROR 13 (HY000): Can't get stat of
'/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt'
>(Errcode: 13)
That's permission. is the dir 755?
PB
Lola J. Lee Beno wrote:
Peter Brawley wrote:
>ERROR 1064 (42000): You have an error in your S
Lola J. Lee Beno wrote:
ERROR 13 (HY000): Can't get stat of
'/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt'
(Errcode: 13)
Never mind . . . I figured that I needed to add LOCAL to the query.
Should have gone back to the manual page for LOAD DATA.
--
Lola - mai
Peter Brawley wrote:
>ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your >MySQL server version for the right
syntax to use near 'standardwttype.txt`
Use single quotes not (dreaded) backticks.
This seems to have fixed one problem. Now, I ha
Lola
>I keep getting an error message:
>ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your >MySQL server version for the right
syntax to use near 'standardwttype.txt`
Use single quotes not (dreaded) backticks.
PB
-
Lola J. Lee Beno wrot
I'm trying to import a set of data into a database (MySQL 5.0.17-max).
Here's the query that I tried to run:
LOAD DATA INFILE `standardwttype.txt`
INTO TABLE StandardWeightType
FIELDS TERMINATED BY `\t`
LINES TERMINATED BY `\r`
(standard_wt_type_id, standard_wt_desc, standard_wt_lud);
And here'
I need to copy data
from TABLE A to TABLE B(Memory Table) on MySql startup or
restart.
MySql --init-file on
startup is obviously something I need to use could I get an example of what a
sql would look like to start the memory table and completely copy data from
table A.
ThanksDonny Lairs
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 22, 2004 1:35 AM
> To: mysql@lists.mysql.com
> Subject: Re: Regarding User creation and loading data
>
> Hello.
>
> What error have you got? Send us
, December 22, 2004 5:19 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: Regarding User creation and loading data
Hi,
Thank you for your reply. When I log in as a DBA user and try to load
data from a file, I am getting an error as "Access Denied", so, here
-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 1:35 AM
To: mysql@lists.mysql.com
Subject: Re: Regarding User creation and loading data
Hello.
What error have you got? Send us compete command that you issued and
the error message.
>Could any one of y
ges on *.* to 'vasja'@'vasinhost' identified by 'vasinpass'
with grant option;
For dml user use something like this:
grant select,insert,update,delete on test.* to 'dml'@'localhost' identified
by 'v';
See:
http://dev.mysql.com
Hi,
Could any one of you help me in creating two users like First user with
all dba privileges as root and the Second user with only dml operations.
And in loading data using LOAD DATA INFILE, if I use the file full path,
I am getting error. And if I put the file in mysql\bin it is
> I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only
> testing to see if I can. So far, I have been able to create the receiving
> table, but not be able to insert the data. (The only difference I see when
> using phpMyAdmin is the collation column on the 4.1.7 server)
>
> Whe
I am moving a table from a 3.23.56 db to a 4.1.7 db. I currently only testing
to see if I can. So far, I have been able to create the receiving table, but
not be able to insert the data. (The only difference I see when using
phpMyAdmin is the collation column on the 4.1.7 server)
When I try
--- mos <[EMAIL PROTECTED]> schrieb: > At 12:23 PM
Thanks a lot, Mike.
It works.
I spent many hours with this problem.
I also tried the trick with a temporary table,
but used the "INSERT" command, which didn't help.
All the best to you,Harald
>
> Harald,
> 1) load the data into
At 12:23 PM 7/9/2004, you wrote:
Hi,
I'd like to load "TEXT"-data of variable length
into an existing table with "CHAR"-columns.
The input file consists of about 4200 lines
with alphanumeric characters and newline only.
Instead of filling up the "TEXT"-column
next to the existing columns, Mysql
app
t; Sent: 7/9/04 12:23 PM
> Subject: Loading data into "TEXT" column;
>
> Hi,
>
> I'd like to load "TEXT"-data of variable length
> into an existing table with "CHAR"-columns.
>
> The input file consists of about 4200 lines
> with alph
What are the delimiters for this file?
-Original Message-
From: Jens Gerster
To: [EMAIL PROTECTED]
Sent: 7/9/04 12:23 PM
Subject: Loading data into "TEXT" column;
Hi,
I'd like to load "TEXT"-data of variable length
into an existing table with "CHAR"
Hi,
I'd like to load "TEXT"-data of variable length
into an existing table with "CHAR"-columns.
The input file consists of about 4200 lines
with alphanumeric characters and newline only.
Instead of filling up the "TEXT"-column
next to the existing columns, Mysql
appends new rows, filling up the
Well pals,
Today I am not writing this message to bother you with
my problems but to pass my warmest thanx to you guys
all. Duncan, Peter , Mike, Cory ... I appreciate your
time and energy in solving the problems I faced on the
above subject.
Special thanx to Duncan for his precise and priceless
Hi there,
I am posting this message again sice my previous post
was vague.
I have recently configured a server which runs redhat
7.2. I followed the installation procedures to install
mysql database and PHP on the same server and they
seem to run properly.
My aim is to load data into a mysql dat
Can you post the code that does the update?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi fellas,
I wrote a php program that loads and displays data
into and from a mysql database. It connectes and
displays the data correctly. But when you fill a form
and click submit it acts as if the data is written on
the data base while isn't if you check it by manual
connection.
What could be
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_namesalary
employee_namesalary
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name & salary as the columns;
I use the command
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_namesalary
employee_namesalary
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name & salary as the columns;
I use the command
2003 15:21
> To: cmars
> Cc: [EMAIL PROTECTED]
> Subject: Re: Bulk loading data
>
> On Tue, Jul 08, 2003 at 09:36:11PM -0700, cmars wrote:
> >
> > I want to insert massive amounts of data in near real-time into a
> MySQL database. The data is in a structured binary
ssage-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003, 9:46 PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Bulk loading data
At 21:36 -0700 7/8/03, cmars wrote:
>Hi,
>I want to insert massive amounts of data in near real-time into a
>MySQL database.
Paul,
Did you try using REPLACE instead of UPDATE/INSERT? Could give you some
more speed enhancement.
Cheers
/rudy
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 15:21
To: cmars
Cc: [EMAIL PROTECTED]
Subject: Re: Bulk loading data
On Tue
On Tue, Jul 08, 2003 at 09:36:11PM -0700, cmars wrote:
>
> I want to insert massive amounts of data in near real-time into a MySQL database.
> The data is in a structured binary format, and I have code that parses the data into
> logical data structures.
...
> How can I load data directly into
implement this functionality in my application, or extend
MySQL to do it?
thanks,
casey
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2003, 9:46 PM
> To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: Bulk loading data
>
&g
At 21:36 -0700 7/8/03, cmars wrote:
Hi,
I want to insert massive amounts of data in near real-time into a
MySQL database. The data is in a structured binary format, and I
have code that parses the data into logical data structures.
Right now I can load into a MySQL database via ODBC, but I need
Hi,
I want to insert massive amounts of data in near real-time into a MySQL database. The
data is in a structured binary format, and I have code that parses the data into
logical data structures.
Right now I can load into a MySQL database via ODBC, but I need to improve throughput.
How can I
On Thursday 03 April 2003 09:28, Justin French wrote:
> I have a 2.7meg dump of SQL created by phpMyAdmin [1], however when I try
> to import this data back into mysql through phpMyAdmin, it times out
> (understandably), so I guess I need to do this from the command line, but
> have no idea how to
I have a 2.7meg dump of SQL created by phpMyAdmin [1], however when I try to
import this data back into mysql through phpMyAdmin, it times out
(understandably), so I guess I need to do this from the command line, but
have no idea how to go about this AT ALL... can anyone point me in the right
direc
Charles Hauser wrote:
All,
I am having difficulty loading data into a DB using a perl script.Linux
RH8 box.
DB creation:
mysql -uroot -p -e 'create database yeast'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
mysql -uroot -p -e
All,
I am having difficulty loading data into a DB using a perl script.Linux
RH8 box.
DB creation:
mysql -uroot -p -e 'create database yeast'
mysql -uroot -p -e 'grant all privileges on yeast.* to [EMAIL PROTECTED]'
mysql -uroot -p -e 'grant all privileges on ye
When I try to use
mysqlimport DatabaseName tablename.txt
from command line, it doesn't work. However, if I use the following command
from mysql prompt
mysql>load data local infile "/home//tablename.txt" into table
tablename.txt
it works. Can anyone tell me how I can load data from the comma
Sean,
Monday, October 07, 2002, 10:11:51 PM, you wrote:
SM> I seem to have run into a rather peculiar problem. I was attempting to load
SM> data into a table from a file. I checked with the online documentation and
SM> found the following syntax:
SM> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE
I seem to have run into a rather peculiar problem. I was attempting to load
data into a table from a file. I checked with the online documentation and
found the following syntax:
LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
I used this format exactly (with my own file and table names of co
> Esp on windows machines this is a good idea, newlines
> there tend to end up being who-knows-what...
It is known exactly what they end up being. Any software that is written
with any sort of vague attempt to be portable and/or actually useful to its
users in a mixed environment, rather than bei
On Friday 21 June 2002 08:31, Roger Baklund wrote:
> * Podhorski, Adam
use the perl "chomp()" function... It strips off any sort of "newlinish"
trash at the end of the line, then explicitly tack a '\n' onto the end before
you feed it to MySQL. Esp on windows machines this is a good idea, newlin
* Podhorski, Adam
> If I don't put the tab before the the end of the line in the txt file that
> contains the data, mySQL does not properly put the data into table using
> LOAD DATA INFILE.
[...]
> But if there is only a \n at the end of the line (e.g.
> 1\tTC446696\tTC27867\n), the data gets corr
Hi!
If I don't put the tab before the the end of the line in the txt file that
contains the data, mySQL does not properly put the data into table using
LOAD DATA INFILE.
The courious thing is that this only happens with this one file. I was using
the same commands for all my other files and this
USING LOAD LOCAL INFILE
Have a database file 15000± records however only approximately 8300 will
load in from the file. I found some of the records that did not load in and
they appear to be ok. So I emptied the loaded fields and tried to just load
approximately 180 records that did not load
Many thanks for any assistance:
I have data (classified ads) in a text file that I would like to load
into a table. The problem is that, as classifieds, they are broken down
by class and sub-class. For instance:
0031 - Announcements
- Notices
One ad
Two ad
- Tick
Hendrik,
Monday, March 18, 2002, 10:04:44 AM, you wrote:
HN> We have problem with moving data to new server. We dumped
HN> database with mysqldump on old server and used
HN> "mysql dbname < db.sql" syntax for database import.
HN> When mysql imports one of our biggest table, then the import fails
Hi
We have problem with moving data to new server. We dumped
database with mysqldump on old server and used
"mysql dbname < db.sql" syntax for database import.
When mysql imports one of our biggest table, then the import fails and
after some minutes gives an error message:
"ERROR 1030 at line 24
>> Hi,
>> I am having problems loading data into a table and have 2 questions.
>>
>> 1)
>> I want to load some data from a text file in to a table by using the
>> following line:
>> LOAD DATA LOCAL INTO "st.txt" INTO TABLE studio;
With this y
LOAD DATA LOCAL INFILE "location of text file" INTO TABLE [tablename]
- Original Message -
From: "Inderpal Singh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 16, 2001 8:12 AM
Subject: Location of text file for loading data in t
Inderpal Singh writes:
> When using the command:
> LOAD DATA LOCAL INFILE "xxx.txt" INTO TABLE [TABLE NAME];
>
> where should the txt file be located?
That's up to you to decide, but as _always_ when you do something
to a file, you must give some sort of valid path (absolute
or relative or wha
Hi,
When using the command:
LOAD DATA LOCAL INFILE "xxx.txt" INTO TABLE [TABLE NAME];
where should the txt file be located?
Thanks
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
---
Hi,
When using the command:
LOAD DATA LOCAL INFILE "xxx.txt" INTO TABLE [TABLE NAME];
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-
e, 04 Dec 2001 14:14:06 +0800
To: [EMAIL PROTECTED]
Subject: Loading data file with MacRoman Character Encoding
Hi All,
I am running Mysql version 2.23.42 on Mac OS X version 10.1.
I need to upload few files in Mysql which are in MacRoman Text Encoding. My
default installation does not
Hi All,
I am running Mysql version 2.23.42 on Mac OS X version 10.1.
I need to upload few files in Mysql which are in MacRoman Text Encoding. My
default installation does not support the MacRoman Encoding.
Currently I need to convert the file into ISO-8859-1 encoding before I can
run the LOAD D
Hi,
I'm having a problem as follows:
In my database (which just needs to work rather than be of commercial
quality) I have an orders table. Each order contains an order number and a
reference to ordered_items. Ordered_items table contains things like the
name of the product and the price.
Now
nal Message -
From: "Ben Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 10:25 PM
Subject: Loading Data
> I have a .sql file that I got from a PHPMyAdmin dump. Now I want to
run the
> sql commands that are in that sql file, possibly
On Tue, Aug 21, 2001 at 03:25:07PM -0500, Ben Davis wrote:
> I have a .sql file that I got from a PHPMyAdmin dump. Now I want to run the
> sql commands that are in that sql file, possibly even including the INSERT
> commands.. I have one that contains just the structure and one that has the
> st
I have a .sql file that I got from a PHPMyAdmin dump. Now I want to run the
sql commands that are in that sql file, possibly even including the INSERT
commands.. I have one that contains just the structure and one that has the
structure and data. What are the commands to run all the queries in
I need to be able to add a .csv file into a database table running on a
mysql server of IP address 10.0.0.10
I know that
"load data infile 'me.txt' into table stock;"
will do the job locally but what's the easiest way for me to add me.txt
to stock on 10.0.0.1?
For arguments sake we can
)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql>
>From: "Milan Kajnar" <[EMAIL PROTECTED]>
>To: "Siomara Pantarotto" <[EMAIL PROTECTED]>
>Subject: Re: Loading data with a txt file
>Date: Thu, 17 May 2001 08:14:14 +0200
>
>Whe
Hi all,
I tried to load data into a table (using a txt file) by following the
example on chapter 9 (pg 9) and it did NOT work. Then I decided to include
the path of the file and it worked fine.
I got curious though. If you omit the path, where does mysql looks for it?
I placed the file into t
LOAD DATA LOCAL INFILE '/path/myfile.txt'
INTO TABLE mytable
FIELDS TERMINATED BY '|';
If the text values are enclosed by double quotation
marks, you need to remove the semicolon in line 3 and
add:
ENCLOSED BY "\"";
If your myfile.txt was created in Windows, you *may*
need to remove the semicol
lt;[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2001 1:47 PM
Subject: Loading Data :-)
> I am still very new to MySQL, I am trying to convert a flat line database
to
> MySQL (Database uses | as a deliminator). I have found what I need in the
> documentation to do this yet I am a b
72 matches
Mail list logo