Hi, I use mysql 5.0 (Centos 5.2) , I have a database, say called opfilter with 2 tables (say aliases and hosts) and I want that slave only replicate tabla aliases and only records from table hosts that match a given criteria, how can i do that?
My current file my.conf on slave is as follows: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 server-id=2 master-host=20.9.13.7 master-user=jojoj master-password=ojojojo master-connect-retry=60 replicate-do-db=opfilter [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid EOF Thanks in advance! -- -- Open Kairos http://www.openkairos.com Watch More TV http://sebelk.blogspot.com Sergio Belkin - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org