MySQL Commands
- Enable/disable MySQL general log (query log)
% set global general_log = 'ON' (or 'OFF')
The file is output to hostname.log by default or we can specify file name in my.ini with "log=fileName"
- Turn on/off Foreign Key checks for dropping schema
% set foreign_key_checks = 1; (or 0 to turn off)
- Check version
% status;
No comments:
Post a Comment