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-requ...@lists.nyphp.org> wrote: > Send talk mailing list submissions to > talk@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-requ...@lists.nyphp.org > > You can reach the person managing the list at > talk-ow...@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 (p...@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 <rewwer1...@gmail.com> > To: NYPHP Talk <talk@lists.nyphp.org> > Subject: Re: [nyphp-talk] Undelete mysql records > Message-ID: > <n2z433f4bb31004150926g865ab35bh4aeb5fe179ce3...@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 <nh...@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 <ro...@omnistep.com> > To: NYPHP Talk <talk@lists.nyphp.org> > Subject: Re: [nyphp-talk] Undelete mysql records > Message-ID: <4bc741b1.8020...@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: p...@blu-studio.com > To: "NYPHP Talk" <talk@lists.nyphp.org> > Subject: Re: [nyphp-talk] Undelete mysql records > Message-ID: > < > 20100415094608.69a71d519390b8693ef02edaf26f7b19.219339ed06....@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 <al...@twomiceandastrawberry.com> > To: NYPHP Talk <talk@lists.nyphp.org> > Subject: Re: [nyphp-talk] Undelete mysql records > Message-ID: <4bc742e9.6060...@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" <m...@atopia.net> > To: "NYPHP Talk" <talk@lists.nyphp.org> > Subject: Re: [nyphp-talk] Undelete mysql records > Message-ID: > > > <948746606-1271350166-cardhu_decombobulator_blackberry.rim.net-15061507...@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: p...@blu-studio.com > Date: Thu, 15 Apr 2010 09:46:08 > To: NYPHP Talk<talk@lists.nyphp.org> > Subject: Re: [nyphp-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" <li...@zaunere.com> > To: "'NYPHP Talk'" <talk@lists.nyphp.org> > Subject: [nyphp-talk] The Largest Web Sites > Message-ID: <00db01cadd6c$c8546120$58fd23...@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@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
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
