Hi kranthi, Take a look at LVM and xtrabackup.
http://www.mysqlperformanceblog.com/2009/02/24/xtrabackup-open-source-alternative-for-innodb-hot-backup-call-for-ideas/ http://marcus.bointon.com/archives/87-MySQL-backups-with-Perconas-XtraBackup.html Krishna CGI (cgi.com) On Sun, Oct 10, 2010 at 10:30 AM, kranthi <kranthikiran....@gmail.com>wrote: > > > Hi , > > My database size is 900GB.i don't want full database backup. I > need only yesterday backup. how can I take, please help me. > > > > Thanks & Regards, > > Kranti > >