help for log files

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 373,936 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,528 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 232 | Replies: 1

•

Join Date: Apr 2008

Posts: 1

Reputation: myuser is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

myuser

Offline

Newbie Poster

help for log files

Apr 13th, 2008

Hello all;

I have a mysql on windows server 2003.
I have deleted some records from mysql table accidently. I need to see log file to recover INSERT commands and run them again to recover my table.
I cant find binary file. but I have a ib_logfile0 and ib_logfile1 file. they are big
and maybe cosists of INSERT commands
but how can I open them? how can I use them?

•

Join Date: Dec 2007

Posts: 102

Reputation: mwasif is an unknown quantity at this point

Rep Power: 1

Solved Threads: 12

mwasif

Offline

Junior Poster

Re: help for log files

Apr 13th, 2008

These are data files. To recover data try these links
http://code.google.com/p/innodb-tools/
http://www.percona.com/services/data...ces-mysql.html

As per my knowledge, you can get INSERT statements if you have enabled query logging.