Hello, My MySQL slave (3.23.51) stopped with the error:
Last_errno: 1146 Last_error: error 'Table 'bts.tmp_na' doesn't exist' on query 'insert into name_address select * from tmp_na ' It is possible that this occured because of inopportune timing in stopping and restarting of the slave. But it seems to me that this could not have been a problem since the my.cnf on the slave has the following entries: replicate-wild-ignore-table=%.tmp% replicate-wild-ignore-table=%.%tmp replicate-wild-ignore-table=%.temp% replicate-wild-ignore-table=%.%temp The documentation seems to save that you put this in the my.cnf on the slave, but maybe it should be on the master as well? Maybe in both places? I will try adding this to the master, but any other suggestions would be greatly appreciated. Thanks, Bill +-------------------------------------------------------- | Bill MacAllister, Senior Programmer | PRIDE Industries | 10030 Foothills Blvd, Dept 1150 | Roseville, CA 95747 | 916-788-2402 --------------------------------------------------------------------- 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