Skip to content

Instantly share code, notes, and snippets.

@CarlRevell

CarlRevell/MySQL-log-to-file

Created December 30, 2013 15:46
Show Gist options
  • Save CarlRevell/8183652 to your computer and use it in GitHub Desktop.
Save CarlRevell/8183652 to your computer and use it in GitHub Desktop.
Download ZIP
Turn on SQL statement logging in MySQL to the file /path/to/your/logfile.log
Raw
MySQL-log-to-file
SET GLOBAL log_output = "FILE"; --which may be set by default, I think.
SET GLOBAL general_log_file = "/path/to/your/logfile.log"
SET GLOBAL general_log = 'ON';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment