MySQL Bugs: #51514: Schemas not showing when I'm trying to synchronize model with database

Bug #51514	Schemas not showing when I'm trying to synchronize model with database
Submitted:	25 Feb 2010 16:31	Modified:	26 Feb 2010 11:30
Reporter:	Leonardo Caporicci	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.16	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	synchronization, synchronize database, synchronize model

Description:
It retrieves schema list from database but I can't select anyone because they are not shown in the next window.
It was working OK until now.

How to repeat:
Synchronize Model with Database

Not showing databases

Attachment: bug51514.PNG (image/png, text), 81.29 KiB.

Hi Leonardo,

does the schema already exist on the server? The way to put your model on a server in the first place is to use the "Forward Engineer" feature. Synchronization is only meant for updating model and/or database schema after changes. So the schema will only appear on the wizard-page when its found on queried database instance.

Yes, the schema already exists on the server but also 'informationschema','mysql' and 'test' databases are not appearing on the list.

Did you reverse engineer your schema first?

I think it was my mistake.
In Workbench 5.1 I can synchronize to any database on the server.
Workbench 5.2 allows me synchronize only to a database with the same name, case sensitive.
That's the solution.