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

Auto Generate Database Diagram for PHPMyadmin DB? [closed]

Tags:

database

phpmyadmin

diagram

i want tool for to generate DB diagram below, i need to generate particular db tables structure like below,

enter image description here

how can i do that?...is there any free tool or application is available for that. i already tried navicat8lite_ora_en and HeidiSQL. but i can't make it work.

like image 951
Ravichandran Jothi Avatar asked Jun 28 '12 14:06

Ravichandran Jothi

People also ask

Can we create ER diagram in phpMyAdmin?

cPanel VPS and dedicated server administrators can access phpMyAdmin from WebHost Manager (WHM). Select the appropriate database name from the left of phpMyAdmin. In the upper-right corner select the “Designer” tab to create a database ER diagram (ERD).

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.

Can we generate ER diagram from database?

Yes! You can export your ERD back into your MySQL, PostgreSQL, SQL Server, or Oracle database. Select the export feature within the entity relationship shape library, choose your DBMS, and Lucidchart will change the syntax of our SQL commands to automatically generate commands you can apply to your matching database.

1 Answers

Yes you can generate ERD with PHPMyAdmin. PHPMyadmin added this functionality from version 3.4

detail step to generate ERD: http://sforsuresh.in/generating-erd-using-phpmyadmin/

You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb

like image 170
Suresh Kamrushi Avatar answered Sep 20 '22 08:09

Suresh Kamrushi
Sign in to Comment

Related questions

Are there any difference between data integrity and data consistency?
Get Connection String from Web.config in asp.net
Import .csv file to Sqlite in Android
how to create table if it doesn't exist using Derby Db
How do I create a database in android? [closed]
MySQL disable & enable keys
How to add a user to PostgreSQL in Windows?
When to use an enum or a small table in a relational database?
Reasons to store users' data in LDAP instead of RDBMS
importing a CSV into phpmyadmin
Difference between NOW(), SYSDATE() & CURRENT_DATE() in MySQL
Compare structures of two databases?
Class Map Generator for Fluent NHibernate
How to Schema Diff two databases using MySQL Workbench?
Best practice to maintain a mgo session
How can I dynamically change the Active Record database for all models in Ruby on Rails?
how to drop all databases except few ones in postgres
Where can I get postal codes for all countries?
Check if a database table exists using PHP/PDO
dbvisualizer: set max rows in a select query

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!