hi, I am setting up replication between two servers, and I have it working for the most part- however- when I do cross-database updates, the changes don't go through to the slave. as in: use mysql; update test.test_table set a=1; I followed the instructions in the manual for replicating only one database: replicate-do-db=database_name ----------------------------- Tells the slave thread to restrict replication to the specified database. To specify more than one database, use the directive multiple times, once for each database. Note that this will only work if you do not use 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.% (Example: replicate-do-db=some_db) So i tried using this in my.cnf: [mysqld] datadir=/var/lib/mysql socket=/tmp/mysql.sock master-host=my_ip master-user=repl master-password=guess master-port=3306 server-id=2 replicate-wild-do-table=test.% but it didn't work. i also tried it with both the replicate-wild-do-table line AND replicate-do-db=test just to see, and then with replicate-do-db=test all by itself, and they all work, but none of the three are working with cross-database queries! anyone know what am i doing wrong here? thanks, todd --------------------------------------------------------------------- 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
