This may be simplistic, but is mysql putting any text before / after blob content, such as column name, '1 row processed OK', that may be 'corrupting' the tar data?
using a very small tar file, and run your command, piping to more instead of tar to see if there is any extra 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 command (tar) > > > 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 dont > > >> >> >get my untared files? write permissions are ok? > > >> >> >what am i missing? > > >> >> > > >> >> Have you verified that the mysql command actually > writes any output, for > > >> >> example, with this command: > > >> >> > > >> > > shell> mysql --pager < test1 | wc > > >> >> > > >> >> Do you get any output from tar at all, such as an > error message? > > >> >> Maybe the output from mysql isn't suitable. Couple > of things to try: > > >> >> > > >> >The output from mysql seems fine because when it does > write the value > > >> >of my blob I get a well formatted tar file, > > >> >I'm thinking that maybe tar cannot handle a stream as > it's input? > > >> > > >> That may be. In that case, you should invoke tar as > > >> > > >> tar xf - > > >> > > > > > >I have tried tar xf but tar gives me an error, it wants a file > > >specified. > > > > But I didn't say to use "tar xf". I said to use "tar xf -". That > > dash is highly significant. It means "The file to read is the > > standard input". > > tried tar xf - > mysql < test1 | tar xf - > tar: This does not look like a tar archive > tar: Skipping to next header > tar: Error exit delayed from previous errors > > I dont get it, if i do this command: > > mysql> select * into dumpfile "/usr/local/test1.tar" from my_table > > I get a tar archive written to /usr/local/ > > I'm using mysql client to store my tar file as a blob, > mysql> insert into my_table values(LOAD_FILE("/usr/local/test1.tar")); > > could this function cause my problem? > Thanks > > > > > > > -- > > Paul DuBois, Senior Technical Writer > > Madison, Wisconsin, USA > > MySQL AB, www.mysql.com > > > > Are you MySQL certified? http://www.mysql.com/certification/ > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
