Skip to content

Instantly share code, notes, and snippets.

@iolloyd

iolloyd/logging.sql

Last active March 15, 2016 16:30
Show Gist options
  • Save iolloyd/d2c54f80444dceb07308 to your computer and use it in GitHub Desktop.
Save iolloyd/d2c54f80444dceb07308 to your computer and use it in GitHub Desktop.
Download ZIP
Enable mysql logging without restarting the mysql server
Raw
logging.sql
-- Make sure you pick somewhere you
-- have permissions to write to.
SET GLOBAL GENERAL_LOG = 'off';
SET GLOBAL GENERAL_LOG_FILE = '/Users/lloyd/mysql.log';
SET GLOBAL GENERAL_LOG = 'on';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment