Re: (binary?) update log for only one database
on a related note to my previous question: how can i switch on the creation of a (binary) update log, but only for ONE database of several being on my server? You probably want to enable the binary log with --log-bin, and use the --binlog-do-db option along with it. Databases not named with --binlog-do-db options will be ignored. http://www.mysql.com/doc/en/Binary_log.html cool. i vaguely remembered an option like that, but couldn't find it yesternight when browsing the docs. i blame caffeine-withdrwal, of course. thanks a lot - exactly what i was looking for. any ideas on that other problem of mine (setting up automatic replication where one 'main server' replicates various 'secondary servers'), by any chance? cheers and thanks, M. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(binary?) update log for only one database
hi again! on a related note to my previous question: how can i switch on the creation of a (binary) update log, but only for ONE database of several being on my server? cheers, M. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (binary?) update log for only one database
At 18:55 -0600 3/25/04, Moritz von Schweinitz wrote: hi again! on a related note to my previous question: how can i switch on the creation of a (binary) update log, but only for ONE database of several being on my server? You probably want to enable the binary log with --log-bin, and use the --binlog-do-db option along with it. Databases not named with --binlog-do-db options will be ignored. http://www.mysql.com/doc/en/Binary_log.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]