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.
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:
Please note the correct syntax. Uppercase tells the server to turn it on and lowercase tells it to turn it off.