Unanswered: Error during replication due to temporary tables
Hi there I am setting up MySQL replication between a linux server running os red hat enterprise 5.6 as the slave and a windows server as the master. I have run into an error with MySQL temporary tables. Within the company I work for there is a process that creates temp tables but these temp tables are critical and cannot be ignored at all. The error we are getting is:
Error 'Table 'Database.temptable' doesn't exist'.
Here is the my.cnf file of the linux slave:
#Replicate musiclender database
#Replication do the tables below
#Replication Ignore these tables below
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
There are many more table ignores but I thought I would just leave one in as there are far to many to show. I read somewhere that these errors can occur when the slave restarted and when MySQL restarts but this didn't happen so this can be ruled at as a problem.
I have read that and it says that temp tables should replicate automatically and only fail if service stops or starts which hasn't happened. I need to replicate temporary data because the temp tables also update other tables that aren't temporary.