Re: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
On Tue, 2003-11-18 at 18:32, Paul DuBois wrote: Please reply to the list, not to me personally, so that others can follow this discussion. that was my intention, sorry, I just used reply from my e-mail client and realized too late that it did not default to the mysql list. At 17:05 -0500

Re: piping blob into shell command (tar)

2003-11-19 Thread Paul DuBois
At 11:03 -0500 11/19/03, Denis Mercier wrote: i also tried: use my_db; select * from my_table; so when i try shell mysql --pager test1 | tar x the tar file does not get written to /usr/local/test1 but i still dont get my untared files? write permissions are ok? what

Re: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote: At 11:03 -0500 11/19/03, Denis Mercier wrote: i also tried: use my_db; select * from my_table; so when i try shell mysql --pager test1 | tar x the tar file does not get written to /usr/local/test1 but i still

RE: piping blob into shell command (tar)

2003-11-19 Thread Dan Greene
is adding in when it's not explictly running 'into dumpfile' -Original Message- From: Denis Mercier [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 1:55 PM To: [EMAIL PROTECTED] Subject: Re: piping blob into shell command (tar) On Wed, 2003-11-19 at 12:26, Paul DuBois

Re: piping blob into shell command (tar)

2003-11-19 Thread Paul DuBois
At 13:55 -0500 11/19/03, Denis Mercier wrote: On Wed, 2003-11-19 at 12:26, Paul DuBois wrote: At 11:03 -0500 11/19/03, Denis Mercier wrote: i also tried: use my_db; select * from my_table; so when i try shell mysql --pager test1 | tar x the tar file does

Re: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
On Wed, 2003-11-19 at 14:02, Paul DuBois wrote: At 13:55 -0500 11/19/03, Denis Mercier wrote: On Wed, 2003-11-19 at 12:26, Paul DuBois wrote: At 11:03 -0500 11/19/03, Denis Mercier wrote: i also tried: use my_db; select * from my_table; so when i try

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
: mysql --skip-column-names test1 | more use test;\nselect * from test;\n \n's are added? -Original Message- From: Denis Mercier [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 1:55 PM To: [EMAIL PROTECTED] Subject: Re: piping blob into shell command (tar

RE: piping blob into shell command (tar)

2003-11-19 Thread Dan Greene
To: [EMAIL PROTECTED] Subject: Re: piping blob into shell command (tar) On Wed, 2003-11-19 at 14:02, Paul DuBois wrote: At 13:55 -0500 11/19/03, Denis Mercier wrote: On Wed, 2003-11-19 at 12:26, Paul DuBois wrote: At 11:03 -0500 11/19/03, Denis Mercier wrote: i also tried

RE: piping blob into shell command (tar)

2003-11-19 Thread Dan Greene
one more idea: try: mysql --skip-column-names --raw test1 | tar xf - -Original Message- From: Denis Mercier [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:41 PM To: [EMAIL PROTECTED] Subject: Re: piping blob into shell command (tar) On Wed, 2003-11-19 at 14

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
-Original Message- From: Denis Mercier [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:41 PM To: [EMAIL PROTECTED] Subject: Re: piping blob into shell command (tar) On Wed, 2003-11-19 at 14:02, Paul DuBois wrote: At 13:55 -0500 11/19/03, Denis Mercier wrote

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
, November 19, 2003 2:41 PM To: [EMAIL PROTECTED] Subject: Re: piping blob into shell command (tar) On Wed, 2003-11-19 at 14:02, Paul DuBois wrote: At 13:55 -0500 11/19/03, Denis Mercier wrote: On Wed, 2003-11-19 at 12:26, Paul DuBois wrote: At 11:03 -0500 11/19/03, Denis Mercier

piping blob into shell command (tar)

2003-11-18 Thread Denis Mercier
here's what im trying to do, i have a tar file in a blob field and i'm trying to retrieve it and pipe it directly into tar to decompress it, without first writing it to the hard drive, here's what i've tried so far, I create a text file called test1: use my_db; select * into dumpfile

Re: piping blob into shell command (tar)

2003-11-18 Thread Paul DuBois
At 16:21 -0500 11/18/03, Denis Mercier wrote: here's what im trying to do, i have a tar file in a blob field and i'm trying to retrieve it and pipe it directly into tar to decompress it, without first writing it to the hard drive, here's what i've tried so far, I create a text file called test1:

Re: piping blob into shell command (tar)

2003-11-18 Thread Denis Mercier
On Tue, 2003-11-18 at 16:40, Paul DuBois wrote: At 16:21 -0500 11/18/03, Denis Mercier wrote: here's what im trying to do, i have a tar file in a blob field and i'm trying to retrieve it and pipe it directly into tar to decompress it, without first writing it to the hard drive, here's what

Re: piping blob into shell command (tar)

2003-11-18 Thread Paul DuBois
Please reply to the list, not to me personally, so that others can follow this discussion. At 17:05 -0500 11/18/03, Denis Mercier wrote: On Tue, 2003-11-18 at 16:40, Paul DuBois wrote: At 16:21 -0500 11/18/03, Denis Mercier wrote: here's what im trying to do, i have a tar file in a blob field