MySQL Forums
Forum List  »  MyISAM

Re: How long I must keep the binary log?
Posted by: Ingo Strüwing
Date: July 18, 2005 07:15AM

This is not a MyISAM question. You better ask in the "General" or "Newbie" forum again.

In my opinion it would be safe to remove all binary logs older than the last full database backup. A recovery means to restore the last full backup and replay the binary logs since that full backup.

But since all backup media might fail, it should become a habit to store at least the last two, better even three, full backups and all binary logs since the oldest stored full backup.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How long I must keep the binary log?
2356
July 18, 2005 07:15AM


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.