Recovering MySQL DB from the logfile

Help!

[trillianjedi]

When things go horribly wrong with a DB (and the backup), is it possible to recreate the DB from the logfile?

My understanding is the Logfile contains all transactions ever made to teh DB, including data.

Is there an app. anywhere to rebuild it?

Thanks,

TJ

[hakre]

hi trillianjedi,

that depends on the log level you use with mysql. you can configure mysql in a certain way, that you've got update , insert and delete logs. with these you can simply reconstruct the data in the db. keep in mind, that using these kind of logs as an additional backup can cause security und hd-capacity issues.