Re: Backup

[kranthi]

I get, I use following 

 

mysqlbinlog --start-date="2010-10-09 9:55:00" \

      --stop-date="2010-10-10 10:05:00" \

      /var/log/mysql/bin.123456 \

   > /tmp/mysql_restore.sql

 

 

Thanks all 

 

 

From: andrew.2.moore@stripped [mailto:andrew.2.moore@stripped] 
Sent: Sunday, October 10, 2010 4:46 AM
To: kranthikiran.inf@stripped
Subject: Re: Backup

 

hmm a yesterday backup? MySqldump using where clauses? Why do you only want
yesterday?

-- Sent from my HTC Desire on 3 --

----- Reply message -----
From: "ext kranthi" <kranthikiran.inf@stripped>
Date: Sun, Oct 10, 2010 04:51
Subject: Backup
To: "backup@stripped" <backup@stripped>

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