mysql 交互式方式记录操作

在以交互式使用Mysql客户端时，将所有结果记录到文本文件中是很有用的，这样可以在以后查看，可以使用tee或者\T选项后面加上文件名（可以加上绝对路径名），来启动日志记录，例如希望将当前的会话记录到mysql_opt.sql中，可以使用：
 
mysql> show databases; \T/home/jfy/tmp/aaa;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| boss               |
| dbtest1            |
| dbtest2            |
| dbtest3            |
| mysql              |
| openca             |
| performance_schema |
| rfsim              |
| test               |
| wollar             |
| zsgtest            |
+--------------------+
12 rows in set (0.00 sec)

Currently logging to file '/home/jfy/tmp/aaa' 

可以一次性使用tee，以后所有指令都可以记录：
 mysql> tee /home/jfy/tmp/aaa;
Logging to file '/home/jfy/tmp/aaa'
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| boss               |
| dbtest1            |
| dbtest2            |
| dbtest3            |
| mysql              |
| openca             |
| performance_schema |
| rfsim              |
| test               |
| wollar             |
| zsgtest            |
+--------------------+
12 rows in set (0.00 sec)

还可以在mysql启动命令上加上参数：
[root@localhost wollar]# mysql --tee=/home/jfy/tmp/aaa
Logging to file '/home/jfy/tmp/aaa'
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 387293
Server version: 5.5.21-log MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

>>>以下是aaa文件内容：
mysql> show databases; \T/home/jfy/tmp/aaa;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| boss               |
| dbtest1            |
| dbtest2            |
| dbtest3            |
| mysql              |
| openca             |
| performance_schema |
| rfsim              |
| test               |
| wollar             |
| zsgtest            |
+--------------------+
12 rows in set (0.00 sec)

Currently logging to file '/home/jfy/tmp/aaa'
mysql> tee /home/jfy/tmp/aaa;
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| boss               |
| dbtest1            |
| dbtest2            |
| dbtest3            |
| mysql              |
| openca             |
| performance_schema |
| rfsim              |
| test               |
| wollar             |
| zsgtest            |
+--------------------+
12 rows in set (0.00 sec)

mysql> quit
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 387293
Server version: 5.5.21-log MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.