Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2011
    Posts
    2

    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:

    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

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    I am not sure why you would want to replicate date that is temporary in the processing pipeline. In any case have you had a look at the following link? http://dev.mysql.com/doc/refman/5.0/...emptables.html
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Oct 2011
    Posts
    2
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •