phpmyadminerd

How to create an ERD using phpmyadmin

How can I create an ERD using phpmyadmin?

Solution

  • You might be using phmpmyadmin of (MAMP/WAMP/XAMP), for these there is no options for more, see here in more details,
    Here are the steps which I used to preferred to generate ERD of DB-

    1. Go to your PHPMyAdmin setup, usually it is “http://localhost/phpmyadmin” in your local machine. (if using mamp it would be http://localhost:8888/phpmyadmin/)
    2. Select the database for which you want to generate.

    3. Select “Designer” from last menu item of more section i.e.
      enter image description here

      (OR)
      if you are using (MAMP/WAMP/XAMP Phmpmyadmin) then-
      enter image description here

    4. You will land on page with different options to create ERD. enter image description here

    5. Once you are done with ERD creation click on “Export Schema" (MAMP/WAMP/XAMP) coordinates for PDF schema.
      enter image description here
      (OR) click on “Import/Export coordinates for PDF schema” icon which is second last in phpmyadmin.

    Hope it will work !!!