MySQL folks, I am having a problem with replication. When I create a new database on the master, the CREATE DATABASE command is not shipped to the slave. Subsequent table creation and table updates on the new database on the master are replicated on the slave, but since the new database was not created on the slave, the slave thread hangs.
In this example the new database is called zzz. This is what I see in the binary log (via mysqlbinlog): ... # at 18236 #021108 14:06:48 server id 5 Query thread_id=72 exec_time=0 error_code=0 use zzz; SET TIMESTAMP=1036782408; create table abc (id int); # at 18289 #021108 14:08:21 server id 5 Query thread_id=72 exec_time=0 error_code=0 SET TIMESTAMP=1036782501; insert into abc values (100); # at 18345 #021108 14:11:52 server id 5 Intvar SET INSERT_ID = 4933; # at 18367 #021108 14:11:52 server id 5 Query thread_id=238 exec_time=0 error_code=0 ... Note that there is a "use zzz", but no "create database zzz". The error from "show slave status" on the slave is error 'Can't create/write to file './zzz/abc.frm' (Errcode: 2)' on query 'create table abc (id int)' Is this a problem? Feature? The master is running 3.23.53a-Max-log. The slave 3.23.49-log. -- Mark -- Mark M. Ito, Thomas Jefferson National Accelerator Facility 12000 Jefferson Ave., Mail Stop 12H, Newport News, VA 23606 Email: [EMAIL PROTECTED], Phone: (757)269-5295 WWW: http://claspc2.jlab.org --------------------------------------------------------------------- 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
