Hi I appear to be having problems with replication and temporary tables.
Up until last week, we have had replication working without any serious problems for 3/4 months; then one of the developers decided to use two temporary tables as work areas. Immediately, replication stopped on the client, so I restarted replication and created a new database and placed this new database in the binlog-ignore-db list. Next day, at the same time replication stopped. After restarting I checked the binary log and found entries in the binary log. So ... Temporary tables do not appear to replicate properly The database server has been restarted since the new database was added and placed in the binlog_ignore_db list Temporary tables appear to go in the log, no matter what you do I am using Red Hat 7.1, and MySQL version 3.23.41. Has anyone seen a problem like this before ? Yours Simon --------------------------------------------------------------------- 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
