MySQL Forums
Forum List  »  MySQL Administrator

Re: backing up mysql binlogs
Posted by: reppal shaik
Date: July 08, 2013 06:40AM

binlog size 1 GB per binlog file. so how will u take backup hourly.
does new binlog get generated every one hour if yes then you can take binlog backup hourly but you should wait for 1GB file to be filled with in one hour.
why don't you go for mysqldump scheduling a cron that will backup database every one hour . use --single-transaction for consistent backup .

Options: ReplyQuote

Written By
June 02, 2013 05:19AM
Re: backing up mysql binlogs
July 08, 2013 06:40AM

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.