On 10/8/2012 8:06 AM, Nuno Rebocho wrote:
> I am a student of Masters and to final project I am planning to
> develop a robust tools for data recovery from the log file of mySQL,
> but for that I need to navigate this.
> I wonder where I can find information about the structure of the log
> file and how can I read (without mysqlbinlog). In the MySQL
> documentation I can not find this information specifies.
> Thank you,
> PS-Sorry if the email is received repeated emails to inform but some
> flaws in reception
For a graduate student in college, you have not impressed me with your
a) MySQL is open source. As you appear to be somewhat proficient in
programming, perhaps you should refer to that and the comments it contains?
b) Google is your friend. I looked for a simple phrase, "mysql binary
log strutcure" and I quickly found many resources OTHER then the general
usage manual that have more details about how the binary log is structured.
(hint: check out the 2nd response - the INTERNALS manual)
You should be very happy I am not going to grade your final project.
There are potentially several flaws with I think you propose to do.
Finding those flaws are left as an exercise for the student (hint:
understand what it is that gets written into the binary logs and the
steps required to initialize replication) . We (the list) will be
pleased to review your findings and provide additional guidance.
(another hint: point-in-time-recovery)
Best of luck!
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN