List:General Discussion« Previous MessageNext Message »
From:Wm Mussatto Date:April 11 2007 4:44pm
Subject:Re: dumpfile question
View as plain text  
On Tue, April 10, 2007 19:45, Paul DuBois said:
> At 10:15 AM +0800 4/11/07, wangxu wrote:
>>follow is my sql:
>>
>>
>>
>>select * into dumpfile '/home/wangxu/test4.data' from mytable ;
>>
>>
>>
>>
>>
>>mysql server report: Result consisted of more than one row
>>
>>
>>
>>why?how to use the "select into dumpfile"?
>
>
>  From the manual:
>
> If you use INTO DUMPFILE instead of INTO OUTFILE, MySQL writes only
> one row into the file, without any column or line termination and
> without performing any escape processing. This is useful if you want
> to store a BLOB value in a file.
>
> http://dev.mysql.com/doc/refman/5.0/en/select.html
>
>
> --
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
Related question. does mysqldump properly escape blobs so that they can be
restored via 'mysql -u xxx -p  databaseName < dumpFile' ?

------
William R. Mussatto
Systems Engineer
http://www.csz.com
909-920-9154

Thread
dumpfile questionwangxu11 Apr
  • Re: dumpfile questionPaul DuBois11 Apr
    • Re: dumpfile questionWm Mussatto11 Apr
  • Re: dumpfile questionwangxu12 Apr