How to turn on MySQL output file logging

Document ID : KB000047965
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

This knowledge article will explain how to turn on mysql logging to an output file.
For example, if you have a large result set being returned and want to review the entire output - sending to a file is generally easier.

Solution:

\T
This will turn on the outfile logging.

Syntax: \T Outfile.out

Without specifying a location it will default to $SPECROOT/mysql/bin directory. If a non-spectrum installation is being used, it will go to $MYSQL_ROOT/bin/

To disable the outfile logging:

\t

Please note the correct syntax. Uppercase tells the server to turn it on and lowercase tells it to turn it off.