MySQL Forums
Forum List  »  Backup

Re: Help! - Innodb and MyISAM accidental DROP DATABASE - 112 tables gone forever?
Posted by: Greg Lehey
Date: July 09, 2006 10:32PM

> I noticed you mentioned mysqlbinlog, which I've noticed mentioned a
> few times while searching around. Please could you explain how you use
> it and on what files to use it.

Yes. mysqlbinlog is a utility program for the replication facility.
Replication works by writing a log file called (wait for it) the
binlog. This log file is created by the master and copied to the
slave(s), who process it to update the slave database. You can find
more about it in the handbook at
http://dev.mysql.com/doc/mysql/en/replication.html.

> The only files I can find are ib_logfile0 and ib_logfile1 are these
> the ones?

No. If you're not running replication, you won't have a binlog, so
unfortunately this solution won't work.

Greg

Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Diary: http://www.lemis.com/grog/diary.html

Are you MySQL certified? http://www.mysql.com/certification/

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.