Auto Generate Database Diagram for PHPMyadmin DB?

database phpmyadmin diagram
Ravichandran Jothi picture Ravichandran Jothi · Jun 28, 2012 · Viewed 80.5k times · Source

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.

Answer

Suresh Kamrushi picture Suresh Kamrushi · Mar 5, 2014

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

Related questions

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6 Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\…

Read More
Can't import database through phpmyadmin file size too large

I have been trying to import Database through phpMyAdmin. My database file is a.sql and it's size is 1.2 GB I am trying to import this on local and phpMyAdmin is saying: You probably tried to upload too large file. …

Read More
Update query PHP MySQL

Can anybody help me understand why this update query isn't updating the fields in my database? I have this in my php page to retrieve the current values from the database: <?php $query = mysql_query ("SELECT * FROM blogEntry WHERE …

Read More