Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've been reading about mysql's binlogs and sql dumps, and I have a doubt: Is there any benefit in using binlogs instead of sql dumps? I know you can use binlogs for making incremental backups -something impossible to do with dumps-, but I wonder if there is another benefits with binlogs.

Bye! And thanks!!

share|improve this question

2 Answers 2

I use a mixed approach for backups: automatic mysqldump during dawn and I keep binlogs to use as an incremental backup since last mysqldump.

But binlogs importance is greater than this: binlogs are also used do set MySQL master-slave replication as they keep the record of every statements that should be replicated to the slaves.

More info about MySQL binary logs here.

Hope this helps.

share|improve this answer
    
Thank you for answering, Marco! Yes, I knew binlogs are used for master-slave replication, although I've never used it :-) But my doubt was related exclusively to backups. If there is some kind of advantage in using binlogs over dumps or if they are complementary solutions. Bye! And thanks!!! –  Matias Jun 29 '10 at 20:12

with binlogs you can roll into any givent moment in past; not just day before, 2 days before etc [assuming you have daily backups]. this can be helpful especially in tracing some possible bugs in your apps using the db.

similarly to Marco i use full dumps+binlogs [for replication purpose and for tracing back].

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.