How to create an ERD using phpmyadmin
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-
- Go to your PHPMyAdmin setup, usually it is
“http://localhost/phpmyadmin”
in your local machine. (if using mamp it would behttp://localhost:8888/phpmyadmin/
) - Select the database for which you want to generate.
Select “Designer” from last menu item of more section i.e.
(OR)
if you are using (MAMP/WAMP/XAMP Phmpmyadmin) then-
You will land on page with different options to create ERD.
- 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 !!!