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