I've been doing a lot of poking around... the actual database is what didn't get created. The CREATE DATABASE statement did make it into the log file, and the slave got past that point without ever creating the database.
Go figure... On Tue, Jan 14, 2003 at 02:06:39PM -0800, Jeremy Zawodny wrote: > On Mon, Jan 13, 2003 at 02:16:23PM -0500, David Nedved wrote: > > > > We keep having issues where we create a new table on the master, and > > a short while later the slave will crash because it starts trying to > > perform queries which insert into the new table, but it looks as if the > > query to create the table hasn't been executed yet (ie the table doesn't > > yet exist on the slave). > > Use "mysqlbinlog" to dump the binary log on the master and see if the > CREATE TABLE statement was logged or not. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 30 days, processed 1,010,822,567 queries (381/sec. avg) > --------------------------------------------------------------------- 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
