I have a running mysql system that doesn't have any logging turned on.
How do I enable the logging without restarting the server? I need to find out why mysql replication is failing.
BTW. I tried /etc/init.d/mysqld reload
But reload wasn't a valid option.
This system is running telephones so restarting it will most likely drop calls which I can't afford to do.
Also tried at the mysql command prompt set log_error='/var/log/mysql/error.log' but it came back and said there was no such system variable. Yet show variables lists it.