Thesql error log issue

logsmy.cnfMySQLmysql-5.5

I have mysql server running successfully.
The error log location is as..

mysql> show variables like '%log_erro%';
+---------------+------------------------+
| Variable_name | Value                  |
+---------------+------------------------+
| log_error     | /var/log/mysql/err.log |
+---------------+------------------------+
1 row in set (0.00 sec)

The issue am facing is that when i am changing the error log location from above to some other location by changing from my.cnf and then restarting the server but the error log is not getting generated and servers starts successfully.

EDIT

After restarting the server the value of the above variable get changed.
but i didn't found the error log in that location.

Best Answer

You may have placed the log-error option under the wrong header.

Put it here:

[mysqld_safe]
log-error=/var/log/mysql/err.log

Then, service mysql restart

I put it there because the mysql service in /etc/init.d calls mysqld_safe to call mysqld. In addition, /etc/init.d/mysql can pass paramaters to mysqld_safe as shown above.

Just to be safe, run this also

mkdir /var/log/mysql
chown -R mysql:mysql /var/log/mysql

Give it a Try !!!

Related Question