Replication Stopped On Slave With Error 1049 'Unknown database on query' (Doc ID 2228726.1)

Last updated on JANUARY 31, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Symptoms

In a Replication Scenario, we verify the slave status and a error is displayed

Last_Errno: 1049
Last_Error: Error 'Unknown database 'mydatabase'' on query.

But in the slave status the mydatabase is part of the Replicate_Ignore_DB

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms