The .output command sets the output destination. By
default, any command output is directed to the terminal
interface (in the case of interactive sessions) or the program
output (in the case of batch sessions). Given a filename, the
.output command will
redirect any command output to a file. The file will be created
if it does not exist. If the file does exist, it will be
truncated. If the output is being redirected to a file, it will
not also be displayed to the terminal. Commands and command
prompts will not be output to the file, making this a suitable
way to generate SQL dump files using the .dump command.
To reset the output to the terminal
interface, set the output to stdout (standard output).