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:
Code:
[mysqld]
#server configurations
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
server-id=2
master-connect-retry=60
sql-mode="STRICT_ALL_TABLES"
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
#Replicate musiclender database
replicate-do-db=musiclender
#Replication do the tables below
replicate-do-table=musiclender.stock_qty_locations
replicate-do-table=musiclender.stock
replicate-do-table=musiclender.locations
#Replication Ignore these tables below
replicate-ignore-table=musiclender.administration
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
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.
Thanks in advance for help revived
-Alex
dBforums
>
Error during replication due to temporary tables
10-11-11, 06:05
Linear Mode
