Do keep in mind that what you get there is going to be useless if your database doesn't already contain all the previous data. The inserts will work, of course, but any data modification may fail because the rows you modify aren't there when you restore.
Make sure you know exactly what you want and what you're doing before implementing this. On Mon, Oct 11, 2010 at 5:10 PM, kranthi <kranthikiran....@gmail.com> wrote: > 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.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com] > Sent: Sunday, October 10, 2010 4:46 AM > To: kranthikiran....@gmail.com > 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....@gmail.com> > Date: Sun, Oct 10, 2010 04:51 > Subject: Backup > To: "bac...@lists.mysql.com" <bac...@lists.mysql.com> > > 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 > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel