List:Backup« Previous MessageNext Message »
From:Shawn Green (MySQL) Date:October 13 2010 2:20pm
Subject:Re: Incremental Backup Script
View as plain text  
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
Thread