Database Relations

[HelioHost]

Since enabling Designer mode in PhpMyAdmin hasn't resulted in any adverse effects on our experimental server it has now been enabled on Stevie as well. Now all Heliohost users can use the graphical interface in PhpMyAdmin to manage their InnoDB database relations. As a reminder of what we're talking about here is the original news post located at http://www.helionet.org/index/topic/22481-phpmyadmin-designer/

 

1. To get started, log in to your Johnny account by visiting http://johnny.helioh...PhpMyAdmin.html
   
2. Next select a database in the left navigation column.
   
3. In the top right corner you'll see a new tab entitled "Designer."
   
4. The tables in the database will be displayed as boxes that you can drag around the screen.
   

For a more detailed tutorial on how to use designer mode check out http://www.yourwebskills.com/dbphpmyadminrelationships.php You can also read up about foreign keys, and how they're used at https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html Using a graphical user interface such as this is by far the easiest and most intuitive way to create relationships within your databases.

 

Please don't hesitate to let us know if you're having any trouble with the new features of PhpMyAdmin. If you have any suggestions on what we should upgrade next we'd love to hear from you. Thanks for being part of the Heliohost community.