mysqldump: Got error: 1049: Unknown database when using LOCK TABLES
Ran in to a confusing error message today:
mysqldump: Got error: 1049: Unknown database 'mydb' when using LOCK TABLESI did have a database named mydb and then deleted it the other day. Later when doing
some scripted mysqldumps of other databases, I got that message. Why in the world was it trying
to lock a database I knew to be gone?
Turns out one of my other dbs was referencing the deleted db in a VIEW. Hope that helps