mysqlsqlworkbench
MySQL: how to convert SQL file to Workbench mwb file
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
Solution
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.
The above is from Workbench 6.3.3
- Setting the ft_min_word_len to 2 via console
- MySQL Workbench auto increment disabled
- Get a list of dates between two dates
- Installing mysql2 gem for Ruby on Rails with Mac OSX 10.6
- MySQL slow query when combining two very fast queries
- mySQL full text index slows query
- FULL OUTER JOIN on TWO MYSQL TABLES WITH 3 RELATING COLUMNS
- MYSQL- python pip install error
- How to connect to a database inside Vagrant
- Common_Model.php exists, but doesn't declare class Common_Model
- How can I solve "Error: MySQL shutdown unexpectedly"?
- Insert a SET element into mysql db table with PHP
- ERROR 1071 (42000) : Specified key was too long; max key length is 3072 bytes
- How to get the last second word from String
- How it works a mysql query with alias?
- Efficient to do math in a MySql "order by" clause?
- AttributeError: 'Engine' object has no attribute 'execute' when trying to run sqlalchemy in python to manage my SQL database
- MySQL combine two columns and add into a new column
- how to get lib_mysqludf_sys.dll file on windows
- Qt5 MYSQL driver not loaded error
- How can I add machines to data already been sharded in SQL database?
- Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)
- how to save marital relationship in a database
- store posts + comments in mysql dbs
- How to make a REGEX pattern in mysql for 3 or more digits that are in sequence?
- Does using ASCII/Latin Charset speed up the database?
- utf-8 vs latin1
- Looking to build myself a tiny, free VMWare image for PHP+MySQL Development
- What difference does WITH GRANT OPTION make?
- In MySQL, which is more efficient: IFNULL or NULLIF?