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?
These are data files. To recover data try these links
http://code.google.com/p/innodb-tools/
http://www.percona.com/services/data-recovery-services-mysql.html
As per my knowledge, you can get INSERT statements if you have enabled query logging.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.