How can I create a log file for mysql, and maintain the log for each database transaction?
1 Answer
There are a variety of MySQL logs. If you're just after a record of changes, the binary log should be ideal for your requirements.
Information on log maintenance is also reference from the page linked above.