Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Turn on Error Logs

By: FYIcenter.com

(Continued from previous topic...)

How To Turn on Error Logs?

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

(Continued on next topic...)

  1. What Is the MySQL Server Daemon - mysqld?
  2. What Are the "mysqld" Command Line Options?
  3. How To Start MySQL Server Daemon mysqld?
  4. How To Properly Shutdown MySQL Server Daemon mysqld?
  5. How Much Memory Does the Server Take?
  6. How To Turn on Query Logs?
  7. How To Turn on Error Logs?
  8. What Is Binary Log File?
  9. How To Turn on Binary Logs?
  10. How To Use mysqlbinlog to View Binary Logs?
  11. How To Run MySQL Server on a Different Port?
  12. How To Connect to MySQL Server on a Different Port?

MySQL Tutorials:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: