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, 3379🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...