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
