NYCPHP Meetup

[Nicholas Hart]

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 all
binlog data and parsing it before reinserting my missing data.

Nick


On Fri, Apr 16, 2010 at 12:00 PM, <talk-request at lists.nyphp.org> wrote:

> Send talk mailing list submissions to
>        talk at lists.nyphp.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.nyphp.org/mailman/listinfo/talk
> or, via email, send a message with subject or body 'help' to
>        talk-request at lists.nyphp.org
>
> You can reach the person managing the list at
>        talk-owner at lists.nyphp.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of talk digest..."
>
>
> Today's Topics:
>
>   1. Re: Undelete mysql records (Roger)
>   2. Re: Undelete mysql records (Rolan Yang)
>   3. Re: Undelete mysql records (ps at blu-studio.com)
>   4. Re: Undelete mysql records (Allen Shaw)
>   5. Re: Undelete mysql records (Matt Juszczak)
>   6. The Largest Web Sites (Hans Zaunere)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 15 Apr 2010 12:26:18 -0400
> From: Roger <rewwer1212 at gmail.com>
> To: NYPHP Talk <talk at lists.nyphp.org>
> Subject: Re: [nycphp-talk] Undelete mysql records
> Message-ID:
>        <n2z433f4bb31004150926g865ab35bh4aeb5fe179ce3736 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> I can't my question answered either.
>
> Robert
>
> On Thu, Apr 15, 2010 at 11:32 AM, Nicholas Hart <nhart at partsauthority.com
> >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
> >
> >
> > _______________________________________________
> > New York PHP Users Group Community Talk Mailing List
> > http://lists.nyphp.org/mailman/listinfo/talk
> >
> > http://www.nyphp.org/Show-Participation
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.nyphp.org/pipermail/talk/attachments/20100415/a31ccfd3/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Thu, 15 Apr 2010 12:41:21 -0400
> From: Rolan Yang <rolan at omnistep.com>
> To: NYPHP Talk <talk at lists.nyphp.org>
> Subject: Re: [nycphp-talk] Undelete mysql records
> Message-ID: <4BC741B1.8020008 at omnistep.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> 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
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 15 Apr 2010 09:46:08 -0700
> From: ps at blu-studio.com
> To: "NYPHP Talk" <talk at lists.nyphp.org>
> Subject: Re: [nycphp-talk] Undelete mysql records
> Message-ID:
>        <
> 20100415094608.69a71d519390b8693ef02edaf26f7b19.219339ed06.wbe at email.secureserver.net
> >
>
> Content-Type: text/plain; charset="us-ascii"
>
> An HTML attachment was scrubbed...
> URL: <
> http://lists.nyphp.org/pipermail/talk/attachments/20100415/74316770/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 4
> Date: Thu, 15 Apr 2010 11:46:33 -0500
> From: Allen Shaw <allen at TwoMiceAndAStrawberry.com>
> To: NYPHP Talk <talk at lists.nyphp.org>
> Subject: Re: [nycphp-talk] Undelete mysql records
> Message-ID: <4BC742E9.6060100 at TwoMiceAndAStrawberry.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> 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 happy to offer some tips on getting the results
> you're looking for.
>
> What have you tried so far, and what results are you getting?
>
> This page is a good starting point, though you may have reviewed it
> already:
> http://dev.mysql.com/doc/refman/5.1/en/mysqlbinlog.html
>
> - Allen
>
> --
> Allen Shaw
> TwoMiceAndAStrawberry.com
>
> "Excellence in Web software development and design"
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Thu, 15 Apr 2010 16:49:25 +0000
> From: "Matt Juszczak" <matt at atopia.net>
> To: "NYPHP Talk" <talk at lists.nyphp.org>
> Subject: Re: [nycphp-talk] Undelete mysql records
> Message-ID:
>
>  <948746606-1271350166-cardhu_decombobulator_blackberry.rim.net-1506150707- at bda188.bisx.prod.on.blackberry
> >
>
> Content-Type: text/plain
>
> Is bin logging definitely turned on?
>
> What's the output of "show master status\G" and "show global variables\G"
>
>
> -----Original Message-----
> From: ps at blu-studio.com
> Date: Thu, 15 Apr 2010 09:46:08
> To: NYPHP Talk<talk at lists.nyphp.org>
> Subject: Re: [nycphp-talk] Undelete mysql records
>
> _______________________________________________
> New York PHP Users Group Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/Show-Participation
>
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 16 Apr 2010 09:57:41 -0400
> From: "Hans Zaunere" <lists at zaunere.com>
> To: "'NYPHP Talk'" <talk at lists.nyphp.org>
> Subject: [nycphp-talk] The Largest Web Sites
> Message-ID: <00db01cadd6c$c8546120$58fd2360$@com>
> Content-Type: text/plain;       charset="us-ascii"
>
> Looks like an excellent resource -
>
>
> http://royal.pingdom.com/2010/04/14/peeking-behind-the-scenes-of-the-worlds-
> largest-sites/<http://royal.pingdom.com/2010/04/14/peeking-behind-the-scenes-of-the-worlds-%0Alargest-sites/>
>
> H
>
>
>
>
>
> ------------------------------
>
> _______________________________________________
> talk mailing list
> talk at lists.nyphp.org
> http://lists.nyphp.org/mailman/listinfo/talk
>
> End of talk Digest, Vol 42, Issue 6
> ***********************************
>



-- 

-Nicholas Hart
Parts Authority IT
516-678-3900 X3242
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20100416/86e43693/attachment.html>