> Replication with temporary table issue: > HostA: MySQL 3.23.42-log > HostB: MySQL 3.23.42 > > Replication: HostA --to--> HostB > > Issue: After followed the MySQL Manual recommendation to: SET SQL_LOG_BIN > = 0; > to create, insert and drop a temporary table, > example: > SET SQL_LOG_BIN = 0; > CREATE TEMPORARY TABLE tempTableA ... > INSERT INTO tempTableA ... > SET SQL_LOG_BIN = 1; > INSERT INTO nomalTableB SELECT * FROM tempTableA <--- it does not > work because tempTableA table has not been replicated. > > Question: Is there a work around for this problem, other than make > tempTableA a normalTableA to get a good replication of it ? > > Thank you in advance.
--------------------------------------------------------------------- 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
