Collections:
Turn on Error Logs in MySQL
How To Turn on Error Logs in MySQL?
✍: FYIcenter.com
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
⇒ What Is Binary Log File in MySQL
2017-11-29, 1597🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...