Mark, Thursday, November 14, 2002, 4:34:19 PM, you wrote: MI> On Thu, 14 Nov 2002, Victoria Reznichenko wrote:
>> MI> I am having a problem with replication. When I create a new database on >> MI> the master, the CREATE DATABASE command is not shipped to the slave. >> MI> Subsequent table creation and table updates on the new database on the >> MI> master are replicated on the slave, but since the new database was not >> MI> created on the slave, the slave thread hangs. >> >> It works fine for me. What replication options are you using? >From the master: MI> server-id=5 MI> log-bin=/group/clas/db/clasdb/logs/clasdb2-bin MI> binlog-ignore-db=diskSpace MI> binlog-ignore-db=mysql >From the slave: MI> server-id=4 MI> master-host=clasdb2.jlab.org MI> master-user=repl MI> master-password=******** MI> So it is all pretty vanilla. The diskSpace database is excluded since it MI> is used as a scratch pad for disk management. Since different mirrors may MI> want different access privilege tables, the mysql database is excluded MI> from replication. I wasn't able to repeat it :-( -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
