From: Shawn Green (MySQL) Date: October 13 2010 2:20pm Subject: Re: Incremental Backup Script List-Archive: http://lists.mysql.com/backup/148 Message-Id: <4CB5C02B.3000505@oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit On 10/13/2010 9:18 AM, kranthi wrote: > Hi > > Please be send sample incremental backup script (bash Shell script > Easy to understand) > > > > Thanks& Regards, > > Kranthikiran > > I think you missed the points of the previous replies. MySQL does not do incremental backups the the same way that other RDBMS products you may be familiar with. You can take full backups (all of the tables and all of the data) and partial backups (some of the tables or some of the data). With those, you can combine the contents of the Binary Log Files to provide yourself with the ability to perform a point-in-time-recovery (PITR). Which combination of backup techniques (and there are multiple techniques) you use depends on your hardware, software, and operational requirements. Please read the fine manual for more details: http://dev.mysql.com/doc/refman/5.1/en/backup-and-recovery.html -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN