Probably worth noting. Turns out if you connect PHP to one database and insert
a record in another database then the
binlogs filter this together with the database you are connected to. In other
words, I wasn't seeing any inserts with
the --database= option in mysqlbinlog. Ended up dumping a
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-tal
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
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 am looking for a way to search all deleted records in a table and undelete
ones that were deleted by mistake. Anyone know of an easy way to do this?
These are ISAM tables. Thanks.
By deleted records, do you mean they were deleted with:
DELETE FROM tableName WHERE ?
Or something like:
