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 <[email protected]> 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: [email protected] [mailto:[email protected]] > Sent: Sunday, October 10, 2010 4:46 AM > To: [email protected] > 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" <[email protected]> > Date: Sun, Oct 10, 2010 04:51 > Subject: Backup > To: "[email protected]" <[email protected]> > > 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
