MySQL: how to convert SQL file to Workbench mwb file

mysql sql workbench
brewphone picture brewphone · Jul 5, 2016 · Viewed 7.6k times · Source

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

Answer

Drew picture Drew · Jul 5, 2016

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

Related questions

Can I use MySQL Workbench to create MariaDB?

I am totally new to databases. I would like to create a database; I am going to make a small project which is going to use DB. I am going to use Maria DB as it is totally free for …

Read More
How to get MySql DB connection information from MySql workbench?

I am trying to connect to a database using ASP.net and C#. I went through the MySql workbench tutorial and created a database, eer model, and table. What I need now is the database connection information, specifically the connection …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More