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
