Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Generate ER Diagram from existing MySQL database, created for CakePHP [closed]

For CakePHP application, I created MySQL database.

Which tool to be used to create ER Diagram of database? Fields and relations between tables are created in a way cakePHP likes.

thank you in advance!

like image 628
user198003 Avatar asked Dec 01 '10 16:12

user198003


People also ask

How do I export a schema diagram from MySQL Workbench?

To export diagram go to menu, select File, then Export, select one of the available formats and provide folder and filename. Here is my diagram: See it in other formats: Sample PDF export.

How do I create a database schema diagram in MySQL?

Open MySQL Workbench. Select File and New Model from the top menu. Select File, hover over Import, and press Reverse Engineer MySQL Create Script…. Specify the SQL file needing a diagram. Press Execute, Next, and then Finish.


1 Answers

Use MySQL Workbench. create SQL dump file of your database

Follow below steps:

  1. Click File->Import->Reverse Engineer MySQL Create Script
  2. Click Browse and select your SQL create script.
  3. Make Sure "Place Imported Objects on a diagram" is checked.
  4. Click Execute Button.
  5. You are done.
like image 119
varun249 Avatar answered Sep 28 '22 20:09

varun249