From: Johan De Meersman (vegivamptuxera.be)
Date: Mon Oct 11 2010 - 05:29:40 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.infgmail.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.moorenokia.com [mailto:andrew.2.moorenokia.com]
> Sent: Sunday, October 10, 2010 4:46 AM
> To: kranthikiran.infgmail.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.infgmail.com>
> Date: Sun, Oct 10, 2010 04:51
> Subject: Backup
> To: "backuplists.mysql.com" <backuplists.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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]