Generating ERD using PHPMyAdmin

Posted on March 5, 2014 by Suresh Kamrushi in Mysql, PHP

Today I need to generate ERD for my Database. If you search on net you will get number of people suggest Workbench for it but as i am using PHPMyAdmin as an GUI for my Mysql database I just don’t want to install workbench only for generating ERD. And above all when PHPMyAdmin support it (from 3.4 version) than what more I need.
So here I am sharing few steps to generate ERD from PHPMyAdmin:

Go to your PHPMyAdmin setup, usually it is “http://localhost/phpmyadmin” in your local machine.

  • Select the database for which you want to generate.
  • Select “Designer” from last menu item i.e. “More”. You will land on page with different options to create ERD.ERD
  • Once you are done with ERD creation click on “Import/Export coordinates for PDF schema” icon which is second last, you will land on page which will ask you to create the page with some name say “ERD V1.0”.Import_ExportcoordinatesforPDFschema
  • Than Click on “Edit or export relational schema” link at the bottom of operation Menu of PHPMyAdmin. On this page select the page as “ERD V1.0” and generate the ERD diagram as PDF document.

My PHPMyAdmin version: 4.0.4.1
My MySql Version: 5.5
That all!!! Its very easy and simple

  Comments or questions are welcome