How to create an 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 don't have that option in the 'MORE' menu.

Thanks!

Answer 1

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.
   

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

4. You will land on page with different options to create ERD.

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

Hope it will work !!!

Answer 2

I guess you are doing this on a shared hosting. You won't find the more option on shared hosting. You can create a local version of your database and use the local phpmyadmin to generate the ERD.