How To Turn on Error Logs


How To Turn on Error Logs? - MySQL FAQs - Server Daemon mysqld Administration



If you want MySQL to write critical errors into a log file, you can use the "--log-error=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option:

>cd \mysql\bin
>mkdir \mysql\logs
>mysqld --log-error=\mysql\logs\error.log

If there is critical errors, your error log will be pretty empty:

>type \mysql\logs\error.log

20:32:21  InnoDB: Started; log sequence number 0 43665
20:32:21 [Note] mysqld: ready for connections.
Version: '5.0.24-community-log'  socket: ''  port: 3306

2007-05-11, 4949👍, 0💬