Hi!
> "Ramon" == Ramon Arias <[EMAIL PROTECTED]> writes:
Ramon> I haven't done the big file yet... I did a smaller one that was 50 gigs, and
Ramon> it loaded fine after a few hours. (about 3) in a pc with tons of ram and
Ramon> scsi stripped drives. However each index take about 3-5 hours
Wednesday, May 01, 2002 12:55 PM
To: 'Ramon Arias'; [EMAIL PROTECTED]
Subject: RE: mysqlimpor and fixed length files.
[snip]
The way that I have been doing it so far is by coverting the source data
into tab delimited format with a 'C' utility that I wrote and then loading
it u
Brian!
Using mysqlimport with no delimiters worked fine.
Thanks a lot...
Ramon
-Original Message-
From: Brian Ivins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:36 PM
To: 'Ramon Arias '; '[EMAIL PROTECTED]'
Subject: RE: mysqlimpor and fixed
[snip]
The way that I have been doing it so far is by coverting the source data
into tab delimited format with a 'C' utility that I wrote and then loading
it using mysqlimport. However I am looking for a way to streamline that
process. I am loading about 100 Gigs of data, so that extra step that I
data this way. However, the on-line manual
now says this isn't supported, so it may be dependant on your MySQL version.
I'm running 3.23.49.
-Original Message-
From: Ramon Arias
To: Jay Blanchard; [EMAIL PROTECTED]
Sent: 5/1/02 9:25 AM
Subject: RE: mysqlimpor and fixed length fi
tep that I am
trying to avoid requires a few hours of waiting an about 50 Gigs of extra
disk space. Any suggestions?
Ramon
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 9:54 AM
To: 'Ramon Arias'; [EMAIL PROTECTED]
Subject: RE:
[snip]
I need to break it up into fields
[/snip]
Just to make sure that I understand...the data currently looks something
like;
100101TestFileData1Data2Data3
and you need the columns to be like;
100101 TestFile Data1 Data2 Data3
If you are on *nix you need to write a script to break up the
On Wednesday 01 May 2002 09:36 am, Ramon Arias wrote:
> Jay
>
> I need to break it up into fields
>
> Ramon
>
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 01, 2002 9:26 AM
> To: 'Ramon Arias'; [EMAI
Jay
I need to break it up into fields
Ramon
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 9:26 AM
To: 'Ramon Arias'; [EMAIL PROTECTED]
Subject: RE: mysqlimpor and fixed length files.
[snip]
Is there a way to import data
[snip]
Is there a way to import data that is in fixed length format into MySQL?
[/snip]
Do you need to break up the data, or can it all just go in one column?
Jay Blanchard
-
Before posting, please check:
http://www.mysql.c
10 matches
Mail list logo
