[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: spool log to a file
From:       walter harms <wharms () bfs ! de>
Date:       2008-07-30 16:09:55
Message-ID: 48909253.605 () bfs ! de
[Download RAW message or body]


that is a shell question using bash/ksh stuff you can use this:

mysql -uroot -pxxx  -Dtest  -s -e  'select * from amc_25;' > aaaa1.txt 2>&1


Ananda Kumar wrote:
> The problem with below statement is that, if i there is any error in sql
> statements it does not get written to aaaa1.txt. So, even if there is any
> error, how can i get it written to aaaa1.txt.
> 
> mysql -uroot -pxxx  -Dtest  -s -e  'select * from amc_25;' > aaaa1.txt
> 
> 
> On 7/29/08, Mary Bahrami <mbahrami@seattletimes.com> wrote:
>> I use
>> mysql -uroot -pxxx  -Dtest  -s -e  'select * from amc_25;' > aaaa1.txt
>>
>> but it would be nice to see other solutions...
>>
>>
>> -----Original Message-----
>> From: Ananda Kumar [mailto:anandkl@gmail.com]
>> Sent: Tuesday, July 29, 2008 6:37 AM
>> To: mysql
>> Subject: spool log to a file
>>
>> Hi All,
>> I am executing below command, but there is no entires in aaaa1.txt, its
>> an
>> empty file. How can i write the logs into this file.
>>
>> mysql -uroot -pxxx  -Dtest  -s   --tee=aaaa1.txt -e  'select * from
>> amc_25;'
>>
>> regards
>> anandkl
>>
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]