I am doing a master/slave replication, but getting errors about my tables does not exist. Is there not a way where i can make the whole table structure replicate aswell? Thought it did on default tbh.

  • Question #1) Are you using Magento ??? – RolandoMySQLDBA Aug 26 '14 at 20:03
  • Question #2) When you run SHOW SLAVE STATUS\G, what do Replicate_Do_DB:,Replicate_Ignore_DB:,Replicate_Do_Table:,Replicate_Ignore_Table:,Replicate_Wild_Do_Table: and Replicate_Wild_Ignore_Table: say ? – RolandoMySQLDBA Aug 26 '14 at 20:07
  • Nope. No CMS or e-commerce system. Custom PHP application. – Adionditsak Aug 26 '14 at 20:07
  • Question #3) When you run SELECT COUNT(1) TableCount FROM information_schema.tables WHERE table_schema NOT IN ('information_schema','mysql','performance_schema'); on the Master and on the Slave, how many tables do they have ? – RolandoMySQLDBA Aug 26 '14 at 20:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.