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 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?
>
> No.
>
> The output when you retrieve the column and send it into the pipe
> contains something that is not part of the column contents itself.
> Likely the column header. Try using the --skip-column-names option
> to suppress the header.
>
I tarred test1 recreated my_table, using LOAD_FILE put in test1.tar
30 B file before tarred, after tarred 10 K
mysql --skip-column-names < test1 | tar xf -
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Error exit delayed from previous errors
mysql --skip-column-names < test1 | more
./test1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\00100644\00000000\00000000\000000000036\007756740530\0011034\0
0\0\0\0\0\0\0\0\
0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\
0\0\0ustar
\0root\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0root\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0
\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0use test;\nselect *
from test;\n\0\0\0\ ............>>lot more but all \0's
I dont know if tarring adds all this extra data? but tarring did
increase the file size from 30 B to 10 K,
I used vi to create test1,
> --
> 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]
