On your mysql monitor do:
mysql> tee filename.out
This will redirect everhting to filename.out besides ptinting it to the screen.
Alternatively from you shell:
$ echo "show status;"|mysql -u thalis -p lala > filename.out
regards,
thalis
On Fri, 4 May 2001, Tim wrote:
>
> Is there any way t
On Fri, May 04, 2001 at 01:48:59PM -0400, Tim wrote:
>
> Is there any way to redirect the output of a 'Show' command to a
> text file?? I know you can do this with a SELECT sql statement...
tee somefile
show tables;
notee
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Financ
echo 'show blah blah blah' | mysql -u user -ppassword >
/directory/filename
Tim wrote:
>
> Is there any way to redirect the output of a 'Show' command to a text
> file?? I know you can do this with a SELECT sql statement...
>
> -TIM
>
> ---
Is there any way to redirect the output of a 'Show' command to a text
file?? I know you can do this with a SELECT sql statement...
-TIM
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http