Replication Stopped On Slave With Error 1049 'Unknown database on query'

(Doc ID 2228726.1)

Last updated on MARCH 29, 2018

Applies to:

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


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



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