Wednesday, June 10, 2009

Log interactive session in MySQL

There are two ways to start recording your interactive session in MySql.

1. From the Command line:
(I'm only typing the command "mysql" and will assume that your username and password is saved in your home directory in ".my.cnf" file.

mysql --tee=filename database
ex: myssql --tee=tmp.txt dl4demo09

2. From within Mysql:
mysql> \T output.file
Logging to file 'output.file'

No comments: