My.cnf log file

The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. MySQL my. Asked 7 years, 4 months ago. Active 5 years ago. Viewed 12k times. Improve this question. Community Bot 1. Jakub Turcovsky Jakub Turcovsky 1 1 gold badge 4 4 silver badges 8 8 bronze badges. Add a comment. Any restart of the server would pick up configuration file settings.

For that, please see Destinations opens new window. The Error Log is populated with start and stop information, and critical events encountered by the server. As such, changes are done through a cnf or ini file changes and a server restart or by seeing "Flushing and Renaming the Error Log File" in the Manual Page link at the bottom here.

Logging cannot be disabled for errors. They are important for system health while troubleshooting problems. Also, entries are infrequent compared to the General Query Log. The following snippet illustrates:. Configuration file changes in cnf and ini files might look like the following. MySQL 5. Again, it was introduced opens new window in 5. Learn more. How to enable MySQL logging? Ask Question. Asked 12 years, 3 months ago. Active 11 months ago.

Viewed k times. S PM Ss PM Improve this question. Community Bot 1. Add a comment. Active Oldest Votes. Even though you used chmod , make sure mysql is the owner of the logs. Switch them on as needed and run mysqladmin flushlogs as needed. Improve this answer. Kalle Richter 5 5 silver badges 17 17 bronze badges. Now logging. Must have been the ownership oversight.

Welsh King 2 2 bronze badges.