RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
r [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 Merc

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
rs > > to see if it works > > > > -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) > >

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) >

RE: piping blob into shell command (tar)

2003-11-19 Thread Dan Greene
9, 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: > &g

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
ng FILE_LOAD(). before: use test; select * from test; after: 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,

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;

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 >>

RE: piping blob into shell command (tar)

2003-11-19 Thread Dan Greene
a text that mysql 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 comma

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 no

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 p

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-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 >

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, > > > >he

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: us