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 strs
that are duplicated
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
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, ,
62527427012682983, 191150, 177628526,
Ok.. Disregard... the spaces I added for troubleshooting after the
commas fubar'd it.
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
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
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
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
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 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/Apache
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
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 wrote:
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
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 -
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 SQL
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
]
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 you help me in creating two users like First user
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/doc/mysql/en/GRANT.html
And in loading data using LOAD DATA INFILE
: 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 you help me in creating
, 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 I
want
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
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
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
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 TEXT
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-columns.
The input file consists
of different length (100 - 3000 chars).
It looks like:
ASEDVFGHGHFDSFDGFG\n
FHFGHFGTZUZUNZTWERTJUKJZUKZUKZTZHTR\n
JHKHKKFHGJJVJGJGJFDHFGJHFJHJH\n
System: Debian/Sarge, MySQL 4.0.18
-Original Message-
From: Jens Gerster
To: [EMAIL PROTECTED]
Sent: 7/9/04 12:23 PM
Subject: Loading data
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
appends
--- 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 a
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 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
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 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
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_nametabsalaryenter
employee_nametabsalaryenter
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name salary as the columns;
I
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_nametabsalaryenter
employee_nametabsalaryenter
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name salary as the columns;
I
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 the
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
-
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. The data
: 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 format, and I have
code that parses the data into logical data structures.
...
How can I load
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
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
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
At 21:36 -0700 7/8/03
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 go
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
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 yeast.* to [EMAIL PROTECTED
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 'grant all privileges
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
mysqlload data local infile /home//tablename.txt into table
tablename.txt
it works. Can anyone tell me how I can load data from the command
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 pet;
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
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
* 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
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
-
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 and
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
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 you have to save your text file inside the bin folder of your
mysql
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
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
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
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 to table
Hi,
When using the command:
LOAD
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 support the MacRoman Encoding.
Currently
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
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.
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 even including the
INSERT
commands.. I have one that contains
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
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
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
66 matches
Mail list logo