Is bin logging definitely turned on?
What's the output of "show master status\G" and "show global variables\G"
-Original Message-
From: p...@blu-studio.com
Date: Thu, 15 Apr 2010 09:46:08
To: NYPHP Talk
Subject: Re: [nyphp-talk] Undelete mysql records
__
Nicholas Hart wrote:
I'm now trying to restore missing data from a prior date using binlogs
but cannot seem to get this to load. Anyone familiar with restoring
data from binlogs? Thanks.
Hi Nick,
I've restored data in this way many times, as I'm sure have others on
this list. I'd be happ
unfortunately, i am not familiar with the procedure on binlogs, but (if the feature is turned on) there is also a mysql query log that you could review that might allow you to reconstruct deleted data. Just a shot in the dark for you.
Original Message
Subject: Re: [nyphp-talk] U
Nicholas Hart wrote:
I'm now trying to restore missing data from a prior date using binlogs
but cannot seem to get this to load. Anyone familiar with restoring
data from binlogs?
Yes.
Did you look at this?
http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html
~Rolan
_
I can't my question answered either.
Robert
On Thu, Apr 15, 2010 at 11:32 AM, Nicholas Hart wrote:
> I'm now trying to restore missing data from a prior date using binlogs but
> cannot seem to get this to load. Anyone familiar with restoring data from
> binlogs? Thanks.
>
> Nick
>
>
>
I'm now trying to restore missing data from a prior date using binlogs but
cannot seem to get this to load. Anyone familiar with restoring data from
binlogs? Thanks.
Nick
___
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/m
On 4/14/2010 15:36, Lester Leong wrote:
Hey all,
The use case here is something similar to what Chris mentioned above, in
that my organization develops and maintains a piece of software and we
host this software on the client's premises, not ours. The obfuscation
is just meant to be another hurdl