Re:Incremental Backup Script

Re:Incremental Backup Script

am 13.10.2010 15:18:56 von kranthi kiran

------=_NextPart_000_000D_01CB6A9E.892213C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi

Please be send sample incremental backup script (bash Shell script
Easy to understand)



Thanks & Regards,

Kranthikiran


------=_NextPart_000_000D_01CB6A9E.892213C0--

Re: Incremental Backup Script

am 13.10.2010 16:20:27 von shawn.l.green

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.h tml


--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org