Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

mysql

mysql-workbench

reverse-engineering

cakephp

er-diagrams

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
Sign in to Comment

Related questions

Using Mysqli bind_param with date and time columns?
How can I undo a mysql statement that I just executed?
How to display UTF-8 characters in phpMyAdmin?
Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user 'root'@'localhost'(using password:YES)
LINQ to SQL multiple tables left outer join
MySQL unknown column in ON clause
mysql SELECT IF statement with OR
Faster way to delete matching rows?
How to know if MySQLnd is the active driver?
how to use LIKE with column name
Rails 3 ActiveRecord: Order by count on association
Getting the number of rows with a GROUP BY query
MySQL find_in_set with multiple search string
Laravel Eloquent compare date from datetime field
MySQL add days to a date
Store UUID v4 in MySQL
Executing "SELECT ... WHERE ... IN ..." using MySQLdb
PHPExcel and Text Wrapping
Group by with union mysql select query
The server time zone value 'AEST' is unrecognized or represents more than one time zone

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!