On Mon, May 27, 2002 at 10:31:06AM -0700, jim hopp wrote: > Greetings, > > We plan to use the binary update log plus backups to enable us to > restore databases and then re-apply updates when necessary. It > appears to me that the binary update log contains updates to all > databases on the mysqld-max process, and that there is no way to > keep a separate binary update log for each database.
There is not, no. Not yet. > Is there any simple way to restore and apply updates to one database > on the server but not any of the others? There's a solution if you don't mind using a newer version. 4.0.2-beta (to be released soon) contains a patch I wrote for the mysqlbinlog program to solve a similar problem. The patch adds a '-d' command-line option so that you can get the data for a single database. Other than that, you'd have to do some log parsing on your own. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 4.0.2: up 3 days, processed 36,659,142 queries (108/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