Creating a database with MySQL Workbench from existing schema/model

mysql database-schema mysql-workbench
TheLettuceMaster picture TheLettuceMaster · Jan 23, 2014 · Viewed 26.7k times · Source

I built a database schema (or Model?) with MySQL Workbench. I'd like to now make it into an actual database.

I've seen Forward and Reverse engineer options and can't find a clear answer on if either are what I need.

How can I turn this into an actual database?

Answer

digitai picture digitai · Jan 23, 2014

This for mysql workbench version 6.0 and for exporting a schema.

Select tab MySQL Model
Select File->Export->Forward Engineer SQL Create

Place a file name to be exported in the Output SQL Script File, choose your options, next 

Export MySQL table Objects,  
filter tables

Then a file is created which you can import to your database and it creates schemas if not exists, creates tables if not exists.

In the case of models, you need to pay, many bucks, for a tool that creates schemas, tables, indexes, cascading, and all stuff associated to an existing data model.

Related questions

How to see indexes for a database or table in MySQL?

How do I see if my database has any indexes on it? How about for a specific table?

Read More
How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
How to store arrays in MySQL?

I have two tables in MySQL. Table Person has the following columns: id | name | fruits The fruits column may hold null or an array of strings like ('apple', 'orange', 'banana'), or ('strawberry'), etc. The second table is Table Fruit and …

Read More