How to create ERD using phpmyadmin

Question

Is it possible to create an ERD using phpmyadmin?

I see people posting the following link: http://goo.gl/0z3vFE

But this does not work for me, for some reason I do not have this option in the "MORE" menu.

Thanks!

Answer 1

Perhaps you are using phmpmyadmin from (MAMP / WAMP / XAMP), there are no more options for them, see here for more details,
Here are the steps that I used to create ERD from DB-

1. Go to configure PHPMyAdmin, usually "http://localhost/phpmyadmin" on your local computer. (when using mamp it will be http://localhost:8888/phpmyadmin/ )
2. Select the database for which you want to create.

3. Select "Designer" in the last menu item of the additional section, i.e.
   

   (OR)
   if you use (MAMP / WAMP / XAMP Phmpmyadmin) then-
   

4. You will be taken to a page with various options for creating ERD.

5. When you are done creating the ERD, click on the “Export Schema ” (MAMP / WAMP / XAMP) coordinates for the PDF scheme.
   
   (OR) click the "Import / Export Coordinates for PDF Schema" icon, which is the second largest in phpmyadmin.

Hope it works !!!

Answer 2

The diagram created in phpmyadmin is not a database diagram. For erd, use the mysql workbench, which gets the database from phpmyadmin and creates erd. For a step-by-step guide, open the following https://www.google.com/amp/s/lopamudrapradhan.wordpress.com/2015/02/16/steps-to-create-er-diagram-of-an-existing- database link using mysql-workbench / amplifier /

Answer 3

I think you are doing this on shared hosting. You will not find more features on shared hosting. You can create a local version of your database and use local phpmyadmin to generate ERD.