Tech Tip: How to turn on MySQL output file logging
CA Spectrum Tech Tip by Bill Wolforth, Senior Support Engineer
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:
To enable the outfile logging.
\T Filename
The Filename in the above syntax is the target file for the output. Please see the sample syntax below.
Syntax: \T Outputfile.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.