Re: backing up mysql binlogs
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 .
Subject
Written By
Posted
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.