Hi ,
You can redirect(copy) the whole action in mysql into a logfile that you specify...
mysql>\?
gives you a list of commands..
Check this link ...
http://dev.mysql.com/doc/mysql/en/mysql_Commands.html
1. 'Tee' is to have a log file ( you can enable and disable it )
mysql>\T <path/to/outfile>
mysql>SHOW TABLES
mysql>\t
[ to disable Tee ]
mysql>\! cat <path/to/outfile>
You can see the whole action there..
2. Alternatively [ to get output alone You can use PAGER like 'more' or 'less']
I think this is what you have asked for ...
mysql>PAGER cat > <path/to/filename>
mysql>SHOW TABLES ;
mysql>\! cat <path/to/mysql>
should show you the results..
Hope this helps..
Regards,
Ram.
[ P.S: Regarding your previos question about unsupported features
Please check the online manual .... for Features not in MySQL..]