Forward engineer is doing nothing in the MySQL Workbench

Question

I have little experience with MySQL Workbench and need some helps to figure out an issue. I loaded a new EER diagram from a .MWB file in the GUI and was trying to convert it into the SQL with Forward engineer. Initially, I was connected to the localhost and when, I press the Forward engineer..., nothing happens. The figure is as following, I'm working in the Mac OS Sierra operating system.

What I am missing here ? Some advice will help from the more expert users.

I use MySQL Workbench 6.3version for the work,

Answer 1

I've had this same issue with the latest release of MySQL Workbench (macOS). It's definitely some bug as previously, I didn't have any issues forward engineering.

Here's a workaround:

Normally, you'd go to:

• Database > Forward Engineer...

To work around this bug, instead go to:

• Database > Synchronize Model...
• This will look for any open ERDs which do not currently exist with the rest of your schemas, and will allow you to forward engineer the schema that way.
• Warning: This could get hairy if you had a lot of ERDs opened and didn't want to synch all of them, so make sure you've got the right ones checked!

I know this is a late answer, but this solution allowed me to forward engineer an ERD which previously was not firing (just as you described, nothing from MySQL Workbench).

I found your post when trying to find a solution, and while troubleshooting, heard via a personal anecdote about this work around. It may already be posted elsewhere on stack (tried to find link but couldn't find it), but hope this helps :)

Answer 2

Try:

File > Export > Forward Engineer SQL CREATE script