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, 1587🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...