0

I have connection to my database in MySQL Workbench and I would like to create erd diagram or if it is possible others diagrams. I have been using Ubuntu 14.04. I tried reading articles and manuals on the official website. They were unhelpful. Can you give me any instruction or advice how not to create my database by hand ?

Improve this question

2 Answers 2

Reset to default
1

Execute the Reverse Engineering Wizard against your database. For additional information, see:

http://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html

This creates an EER diagram and model from your database.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thank you, it works super. But database looks like a set of table, maybe you know how to do it like a complex schema ?
0

You can export your database for an file. For example in MySQLAdmin http://dev.mysql.com/doc/workbench/en/wb-admin-export-import.html

And then you can import this in your Workbench

  1. Under Server Administration on the Home window select the server instance you want to restore database to (Create New Server Instance if doing it first time).

  2. Click on Manage Import/Export

  3. Click on Data Import/Restore on the left side of the screen.
  4. Select Import from Self-Contained File radio button (right side of screen)
  5. Select the path of .sql
  6. Click Start Import button at the right bottom corner of window.

How can I import data into mysql database via mysql workbench?

This will build your database model

Improve this answer

1 Comment

It wasn't an answer for my question in real, but it is helpful for the import/export task. Thank you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.