Hello All, What I would like to be able to do is have individual update logs for each of my databases rather than have one update log which gets written to by all the databases and contains various use <db_name>; statements to distinguish between the databases. The server version this question relates to is 3.22.32. So, if I have a db called test, I would like all DML related to this db to be placed in a log file call, say updatelog_test.001 and for a db called test2 to be written to a log file called updatelog_test2.001. At the moment, in /etc/my.cnf I have the 'log-update=updatelog' option set, and I have written a script that will go through our update logs (which get flushed on the hour) to extract the updates that are relevant to the desired database, re-directing those to a file, which would then be applied to our nightly dump of the db if we had to reconstruct it. But instead of the updatelog containing updates to all of our mysql databases I would like an updatelog for each one. So does anyone know if it is possible to do this. If so, thanks in advance. I have to say that looking through the docs. and manuals, there doesn't seem to be any options that indicate this is possible - but you live and learn and I am probably wrong!. Hope what I want to do is clear. Thanks in advance, William Hargrove www.dsc.net --------------------------------------------------------------------- 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
