[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 764
  • Last Modified:

MySQL replication error: Unknown table on query drop table scratch

I am experiencing a replication error Unknown table on query drop table scratch.
0
DBDevOne
Asked:
DBDevOne
1 Solution
 
JakobACommented:
Please tell more, situation, name of table, ...
0
 
SqueebeeCommented:
Odds are the slave had a query for a table that was not present on the slave. You need an exact copy of the master's tables before you start replication.
0
 
DBDevOneAuthor Commented:
Thank you!
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now