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
ist [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 10:16 AM
To: mysql@lists.mysql.com
Subject: Outfile syntax and out of memory
Hi,
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
al Message-
From: Johan Lundqvist [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 10:16 AM
To: mysql@lists.mysql.com
Subject: Outfile syntax and out of memory
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql
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.
Hi,
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 g
