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
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
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
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
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 never get a