How can I create a log file for mysql, and maintain the log for each database transa开发者_C百科ction?
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.
精彩评论