Creating log of MySQL Command-line Sessions

Creating log of MySQL Command-line Sessions, Creating log in MySQL, Logging your MySQL Command-line sessions, MySQL tee Command Example, MySQL notee Command Example, MySQL tee Saving our output to a file


Sometimes we may require to review our commands that are executed in MySQL. So, if we have a log of our commands, it may be helpful to see what changes we have made. There's an important MySQL command that enables the log of commands executed in MySQL.

The command is as:

tee path_of_file_for_storing_logs

e.g   tee C:\logs\log1.txt

Now each command executed is tracked and the log of them is maintained in the log file.

There may be a need to end the logging process. This is done by a command called:

notee 

This is very useful command if we need to revert some changes we have made. Database administrators require this to administer every changes made to the database. If there are some errors, they can be traced easily.