I just downloaded 3.23.52 from the mysql servers and the version of mysqlbinlog in there doesn't have the -d option you are talking about.
---------------- Thanks Jefferson Cowart [EMAIL PROTECTED] Support Open Instant Messaging Protocols http://www.petitiononline.com/openIM/petition.html > -----Original Message----- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 17:04 > To: Jefferson Cowart > Cc: [EMAIL PROTECTED] > Subject: Re: Binary Update Logs > > > On Fri, Aug 30, 2002 at 04:39:08PM -0700, Jefferson Cowart wrote: > > > > Is there a way to parse the binary update logs and get separate > > binary files for each database? I am hosting mysql databases for > > people and I want to be able to give each of them binary logs but > > only want updates for their DB in the logs they get. I understand > > that streaming these might be hard, but if I can get a script that I > > can cron to run every day that will cause mysql to start a new log > > and then split the old one out to 1 file/db that would be pretty > > good. I was wondering/hoping that someone else had solved this > > problem before I go off and try to figure it out. > > Newer versions of 'mysqlbinlog' have a '-d' command line option so > that you can get all the stuff for a single database (plus some extra > harmless stuff). > > That ought to get you most (if not all) of the way there. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 24 days, processed 512,115,748 queries > (240/sec. avg) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
