MySQL: how to convert SQL file to Workbench mwb file

Question

I have a sql file that creates a database with all tables. But I want to work on the database in MySQL Workbench which provide UI interface. So I think I need to create a MySQL Model from the database that created by the SQL file. Didn't find a way to do it. There must be a way. Searched but all are from mwb to sql. Please help. Thanks

Best Answer

If you already have created your model, you will need to do a reverse engineer, with this you can see the model and then go to file - save model, this will save your model as mwb

Step 1

enter image description here

Step 2 ( Next , next, select your database and click execute)

enter image description here

Step 3 (In your EER view go to File - save model as)

enter image description here

Accepted Answer

From the Home Screen on MySQL Workbench, click the arrow seen below that I circled in Red and create the model either based on an existing db or a script. It will bring up the Reverse Engineer screen. Proceed accordingly.

enter image description here

The above is from Workbench 6.3.3

MySQL: how to convert SQL file to Workbench mwb file

Best Answer

Step 1

Step 2 ( Next , next, select your database and click execute)

Step 3 (In your EER view go to File - save model as)

Random Posts