On 31 Mar 2003 at 16:39, Dyego Souza do Carmo wrote: > this is a bug... because i modify the database escribaupdate from > database mysql and this is not logged...
Yes, it is a bug, but you can work around it by using replicate-wild- do-table. See the documentation for the replicate-do-db option: | Tells the slave thread to restrict replication to commands where | the current database (i.e. the one selected by USE) is | database_name. To specify more than one database, use the | directive multiple times, once for each database. Note that this | will not replicate cross-database queries such as UPDATE | some_db.some_table SET foo='bar' while having selected a | different or no database. If you need cross database updates to | work, make sure you have 3.23.28 or later, and use | replicate-wild-do-table=db_name.%. http://www.mysql.com/doc/en/Replication_Options.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]