Re: Difference between ib_logfile and the binary log file

[Leo Hopkins]

I work on linux so i can guide on dat.
Well on linux, go to the folder where ur mysqlbinlog files are there and there then use the command to read the binary log file in ASCII characters

$ mysqlbinlog mysql-bin.<logfile-number*>

* logfile-number is the actual logfile id u want to read.

Same can b done to read the iblogfile i.e. go to the folder where ur iblogfile resides and dere use the command

$ strings ib_logfile<file-no.**>

** file-no is the id of the iblogfile

I hope u r clear with this.