I already search about fn_dblog and it is about transaction log and it is used in SQL SERVER. if there any way to do transaction log in MySQL like fn_dblog? i can't find one
Yes, you can use mysqlbinlog. Here are a few tutorials:
- 15 mysqlbinlog Command Examples for MySQL Binary Log Files
- Identifying useful info from MySQL row-based binary logs
- mysqlbinlog documentation for your version (going by the mysql-5.6 tag you used)
-
okay, thank you. it's really helped me. Just want to ask a question, is there same between a binary log and transaction log? – syabell rass Jul 23 '18 at 15:37
-
1@syabellrass that's another question, if this answers your question you should accept this answer – Evan Carroll Oct 20 '19 at 1:33