+ Reply to Thread
Results 1 to 3 of 3

Thread: Setting up relationships in phpMyAdmin

  1. #1
    denzil is offline x10 Sophmore denzil is an unknown quantity at this point
    Join Date
    Jan 2011
    Location
    South Africa
    Posts
    134

    Setting up relationships in phpMyAdmin

    I hope this is the right place for this thread.

    I was wondering if it's possible to set up relationships for my database using phpMyAdmin on this server. If so, please direct me because I have been looking for it and cannot find it.

    Thanks a lot

  2. #2
    misson is offline x10 Spammer misson is a jewel in the rough
    Join Date
    Mar 2008
    Location
    Libertatia
    Posts
    2,506

    Re: Setting up relationships in phpMyAdmin

    This forum is ostensibly for help with 3rd party apps you've installed, rather than for the apps X10 provides for site administration. On the other hand, phpMyAdmin is an app created neither by you nor X10, so is thus "3rd party". The free hosting forum might be more appropriate (a forum admin can move the thread to an appropriate forum, if necessary).

    As for your problem, if you mean "relationship" in a relational model theoretical way (which is called a "table" in common parlance), you can create them in different ways, depending on whether the database has no tables or has tables (a web search may turn up better tutorials; at some point, I may add one to X10's wiki, or to phpMyAdmin's). Databases and users must be created from cPanel. If by "relationship" you mean "foreign key", you would use the "Relation View" link on the "Structure" tab for the table. However, it looks as though the relation view feature isn't enabled on X10. If you want it, request it in the Feedback and Suggestions forums (include a poll to get others' support). You can always create foreign keys by running SQL queries from phpMyAdmin. Both tables must be InnoDB, and the column(s) must be indexed on the foreign table.
    Last edited by misson; 01-20-2011 at 04:54 PM.
    Be sure to read all pages linked in this post; they have further information that should prove useful. When asking for help, make sure you follow Eric Raymond's and Jon Skeet's guidelines for prompt, accurate responses. Please answer any questions I ask; they're not rhetorical (probably). Any posted code is intended as illustrative example, rather than a solution to your problem to be copied without alteration. Study it to learn how to write your own solution.
    Misson, not Mission.

  3. #3
    vv.bbcc19's Avatar
    vv.bbcc19 is offline Community Advocate vv.bbcc19 is just really nice
    Join Date
    Jun 2010
    Location
    India
    Posts
    1,505

    Re: Setting up relationships in phpMyAdmin

    Quote Originally Posted by denzilb22 View Post
    I hope this is the right place for this thread.

    I was wondering if it's possible to set up relationships for my database using phpMyAdmin on this server. If so, please direct me because I have been looking for it and cannot find it.

    Thanks a lot
    Can you be more precise about the relationship question?
    Please post an example task of relationship so that I can understand and if can learn from the answers as well.
    Kindly post the same.
    Regards,
    VVBB
    BCV | Community Support Representative
    █ x10Hosting - Giving Away Hosting Since 2004
    Premium Hosting | VPS Services

+ Reply to Thread

Similar Threads

  1. my.ini setting
    By kedai.corner63 in forum Free Hosting
    Replies: 0
    Last Post: 11-20-2010, 07:09 AM
  2. setting up
    By andy_d in forum Free Hosting
    Replies: 4
    Last Post: 03-03-2010, 07:57 AM
  3. FTP setting
    By jakut in forum Introductions
    Replies: 1
    Last Post: 06-26-2008, 04:00 PM
  4. relationships 101
    By tgkprog in forum Off Topic
    Replies: 0
    Last Post: 03-09-2008, 05:34 PM
  5. Setting up an IRC
    By GamingX in forum Feedback and Suggestions
    Replies: 9
    Last Post: 09-19-2007, 07:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers