Re: Retrieve a binary file from a mysql database

[karim bernardet]

[EMAIL PROTECTED] wrote:

From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysql -e
"SELECT ..." > outfile to generate the file
 

thanks for yours answers,
My database is filled with  phpmyadmin
but when I do :
mysql -u karim -p vdc2 -e "select file from Check_log where 
Check_log_id=1  "> toto.tar.gz

the file toto.tar.gz is not good ( a select *** into dumpfile gives the 
good file on the server)
is it a problem of escaped character ?

Karim.



On Fri, 12 Sep 2003, karim bernardet wrote:

 

Hello,

Is it possible to retrieve a file stored in a blob field using a mysql
client from a host which is not the server ?
Thanks for your help,

Karim.

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