Hi Johan,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql > outfile.txt
"outfile.txt" it looks something like:
"OrderID", "Quant", "OrdrDate", "code1", "code2"...
10021, 12, 20060412, 23, 95...
10022, 5, 20060412, , 75...
But, I
Hi,
Where should I increase max_allowed packet??
I get a error from Windows (yes, I know... it's running on a M$-os, not
my bad - not my desicion).
The results is about 2 - 10 Gb of data.
Regards,
/Johan
Dilipkumar wrote:
Hi,
Increase max_allowed packet to 1.5 gb and then try to import you
Hi George,
To do it incrementally is not really an option, since i have to run it
as a script during a short time-frame every night, and theres simply not
time to process the files.
The outfile is about 2 - 10 Gb every time.
The tables have about 100 - 180 columns, and to do a COALESCE would
Johan,
have you thought about doing this incrementally?
ie - 25% at a time x 4
to show something for NULL, you can use the
COALESCE function.
ie - COALESCE(column,'nothing')
--
George Law
VoIP Network Developer
864-678-3161
[EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
-Original Message-
Hi,
Increase max_allowed packet to 1.5 gb and then try to import your data .
eg ;
In mysql prompt run the file as
*use database
\. /tmp/filename.txt
*
Johan Lundqvist wrote:
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.
Bob, That did the trick!
Thanks!
Mike
-Original Message-
From: Bessares, Bob [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 6:03 PM
To: [EMAIL PROTECTED]; Mike Koponick
Subject: RE: OUTFILE to CVS with headers
well,
you can easily output into a comma separated file but the
well,
you can easily output into a comma separated file but the INTO OUTFILE option will not
allow you to retain the headers. You will need to build the logic into a perl script
or language of your choice to get the headers there. Sounds like your fields records
are all on one line becausing yo
As far as I can tell it works from root (Linux, BSD) but may not be the case
for all distros. Do a quick test and you will be able to find out.
HTH!
Jay
mysql, query, sql
Always reply to the list, so that others may participate in the discussion.
---
[snip]
Is there a way to designate which folder on the server the OUTFILE ends
up in? Will it accept a full path in the file name?
[/snip]
yep, even something like "/somefolder/someotherfolder/somefile.foo"
HTH!
Jay
mysql, sql, query
"It's hip to snip!"
-
Rutledge,
Monday, May 13, 2002, 6:25:42 PM, you wrote:
Reoen> Sorry to bother the list with the mundane, but I have searched the
Reoen> entire MySQL manual and can't find the answer. Is there a way to output
Reoen> the table description (using DESCRIBE) into an OUTFILE like you can for
Reoen> SE
You can do it using tee command in your mysql shell.
See: http://www.mysql.com/doc/m/y/mysql.html
Gurhan
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 11:26 AM
To: Mysql List (E-mail)
Subject: OUTFILE and DESCRIBE
Sorry to bother the lis
11 matches
Mail list logo
