List:General Discussion« Previous MessageNext Message »
From:wangxu Date:April 12 2007 12:57am
Subject:Re: dumpfile question
View as plain text  
no,
please use "load data infile" function.
----- Original Message ----- 
From: "Wm Mussatto" <mussatto@stripped>
To: <mysql@stripped>
Sent: Thursday, April 12, 2007 12:44 AM
Subject: Re: dumpfile question


> 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
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1gxu@stripped
> 
>
Thread
dumpfile questionwangxu11 Apr
  • Re: dumpfile questionPaul DuBois11 Apr
    • Re: dumpfile questionWm Mussatto11 Apr
  • Re: dumpfile questionwangxu12 Apr