CREATE DATABASE command is not replicated in the slave server. The database is created on the master but not on the slave. The SQL statement does not appear in the replication log file on the MASTER. I have set the master to ignore replicating one database on the master. Is this causing MySQL from replicating any new databases created onn the master? Any help is appreciated. Kannan my.cnf in the MASTER: log-bin=/usr/local/mysql/var/replication.log server-id=1 binlog-ignore-db=old my.cnf in the SLAVE: master-host=mymach1 master-user=userid master-password=passwd server-id=2 log-slave-updates log-bin=/usr/local/mysql/var/slave.log MYSQL Version Info: mysql Ver 11.11 Distrib 3.23.31, for hp-hpux11.00 (hppa2.0w) _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com --------------------------------------------------------------------- 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
