{"id":4728,"date":"2018-10-25T16:39:17","date_gmt":"2018-10-25T16:39:17","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2018\/10\/25\/create-database-diagram-in-phpmyadmin\/"},"modified":"2022-03-02T11:13:49","modified_gmt":"2022-03-02T16:13:49","slug":"create-database-diagram-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/","title":{"rendered":"Create a Database Diagram in phpMyAdmin"},"content":{"rendered":"
\"How<\/figure>\n\n\n\n

phpMyAdmin<\/strong> is primarily used as a server database management application. But the MySQL\/MariaDB software also has a basic entity relationship diagram tool for development and planning purposes.<\/p>\n\n\n\n

For many this can prevent the need to download desktop software for visualizing relationships between database tables (one-to-one, one-to-many, many-to-many). That is, unless you need highly customized entity relationship (ER) diagrams and ER diagram tools for starting from scratch in collaborative projects. In those cases, you\u2019d likely benefit from software similar to MySQL Workbench, DBeaver, or Draw.io.<\/p>\n\n\n\n

Otherwise, read on to learn how to create a database diagram in phpMyAdmin Designer with minimal effort.<\/p>\n\n\n\n

<\/div>\n\n\n\n

How to Create a Database Diagram in phpMyAdmin<\/h2>\n\n\n\n
  1. Open phpMyAdmin. Shared hosting users may need to first log into cPanel<\/a>. cPanel VPS and dedicated server administrators can access phpMyAdmin from WebHost Manager (WHM).<\/li>
  2. Select the appropriate database name from the left of phpMyAdmin.<\/li>
  3. In the upper-right corner select the \u201cDesigner\u201d tab to create a database ER diagram (ERD). All tables will be populated by default.<\/li>
  4. You can drag-and-drop tables and select the gear icon for more details. Hover your cursor over the menu on the left to see more Designer options such as adding a blank page, table, or entity relationship. The screenshot below shows a basic WordPress database with the Designer menu expanded. Note that there are no relationships in the default WordPress database.
    \"WordPress<\/figure><\/li>
  5. Once you\u2019re done making necessary changes, select \u201cExport schema\u201d from the menu on the left.
    \"Export<\/figure><\/li>
  6. Select your preferred export options (file type, display settings, etc.) and \u201cGo\u201d to save the ER diagram to your local machine.
    \"phpMyAdmin<\/figure><\/li>
  7. If you need to make any changes to the exported file, we have a list of recommended image and PDF editing applications<\/a>.<\/li><\/ol>\n\n\n\n

    If you want more information on the phpMyAdmin Designer feature, select the \u201cHelp\u201d option in the left-hand menu. Learn more about how to get the most out of phpMyAdmin and working with databases<\/a>.<\/p>\n\n\n

    \r\n

    Scalable VPS Infrastructure, Fully Managed<\/strong><\/p>\r\n

    When shared hosting can't handle your traffic, VPS delivers dedicated resources that scale with demand. Our team manages the technical complexity while you manage your business.<\/p>\r\n

    \"checkNVMe Storage    \"checkHigh-Availability    \"checkIronclad Security    \"checkPremium Support<\/p>\r\n

    VPS Hosting<\/a><\/p>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    phpMyAdmin is primarily used as a server database management application. But the MySQL\/MariaDB software also has a basic entity relationship diagram tool for development and planning purposes. For many this can prevent the need to download desktop software for visualizing relationships between database tables (one-to-one, one-to-many, many-to-many). That is, unless you need highly customized entity Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4288,4305],"tags":[],"class_list":["post-4728","post","type-post","status-publish","format-standard","hentry","category-website","category-databases"],"acf":[],"yoast_head":"\nCreate a Database Diagram in phpMyAdmin | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn how to create a database diagram in cPanel phpMyAdmin\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create a Database Diagram in phpMyAdmin | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a database diagram in cPanel phpMyAdmin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-25T16:39:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-02T16:13:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram-1024x538.jpg\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"Create a Database Diagram in phpMyAdmin\",\"datePublished\":\"2018-10-25T16:39:17+00:00\",\"dateModified\":\"2022-03-02T16:13:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\"},\"wordCount\":331,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram-1024x538.jpg\",\"articleSection\":[\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\",\"name\":\"Create a Database Diagram in phpMyAdmin | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram-1024x538.jpg\",\"datePublished\":\"2018-10-25T16:39:17+00:00\",\"dateModified\":\"2022-03-02T16:13:49+00:00\",\"description\":\"Learn how to create a database diagram in cPanel phpMyAdmin\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram.jpg\",\"width\":1200,\"height\":630,\"caption\":\"How to Create a Database Diagram in phpMyAdmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create a Database Diagram in phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create a Database Diagram in phpMyAdmin | InMotion Hosting","description":"Learn how to create a database diagram in cPanel phpMyAdmin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"Create a Database Diagram in phpMyAdmin | InMotion Hosting","og_description":"Learn how to create a database diagram in cPanel phpMyAdmin","og_url":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2018-10-25T16:39:17+00:00","article_modified_time":"2022-03-02T16:13:49+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram-1024x538.jpg","type":"","width":"","height":""}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"Create a Database Diagram in phpMyAdmin","datePublished":"2018-10-25T16:39:17+00:00","dateModified":"2022-03-02T16:13:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/"},"wordCount":331,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram-1024x538.jpg","articleSection":["Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/","url":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/","name":"Create a Database Diagram in phpMyAdmin | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram-1024x538.jpg","datePublished":"2018-10-25T16:39:17+00:00","dateModified":"2022-03-02T16:13:49+00:00","description":"Learn how to create a database diagram in cPanel phpMyAdmin","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2021\/11\/phpmyadmin-create-er-diagram.jpg","width":1200,"height":630,"caption":"How to Create a Database Diagram in phpMyAdmin"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/create-database-diagram-in-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Create a Database Diagram in phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=4728"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4728\/revisions"}],"predecessor-version":[{"id":94605,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/4728\/revisions\/94605"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=4728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=4728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=4728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}