How to create a log file.

[marklenel]

Hello,

I am in the 'thinking' stage of migrating a fairly data-intensive MS Access process to MySQL, in order to improve the performance of the batch of queries. These queries are invisible to the standard user, the only user interaction being a VBA-built front end and an Excel output at the back end. I'll use ODBC to control the background process in MySQL.

I'd like however to record any messages, errors, etc (that normally appear at the MySQL CLI) into a simple text file - ideally with a unique / controllable file name - so that should anything go wrong I have a quick reference for debugging.

If anyone can point me in the right direction I'd be grateful.

 

[TonyGroves]

If you enable general logging in MySQL, all server activity, including the text of every query, is logged. However, this doesn't include details of error messages. It would be the job of your applications to log those.

-----
ALTER world DROP injustice, ADD peace;