#1
  1. No Profile Picture
    Banned
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Davie, FL
    Posts
    0
    Rep Power
    0

    Doing More with phpMyAdmin (Part 2)


    Doing More with phpMyAdmin \(Part 2\)

    "In the first segment of this two-part tutorial, I gave you a quick overview of some of the interesting new features available in phpMyAdmin. In this concluding segment, find out how to use phpMyAdmin to define relationships between tables, maintain a log of commonly-used queries and create entity-relationship diagrams."

    Discuss the article in this thread. You can read the article here .
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Rotterdam
    Posts
    76
    Rep Power
    12
    Thanks for this nice tutorial!
    2 comments.

    1:
    At the bottom of page 2 it says
    Windows users, be warned: MySQL automatically lowercases table names on Windows, so make sure that the names you're entering into the configuration file match the actual table names.
    Yet the query uses uppercases for PMA, where in the config.inc.php example lowercases are used. It took me a while to figure this out.
    So all nonwindows users must use
    $cfg['Servers'][$i]['bookmarktable'] = 'PMA_bookmark'; etc.

    2:
    the image on page 5 where it says:
    you'll be asked for a value for the sid variable
    is not the image meant
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Posts
    1
    Rep Power
    0

    Question


    Hi - great tutorial - it has good information - some of which I did not yet know...

    on pg 6 you state
    use the Edit PDF Pages link at the bottom of the page
    In my phpmyadmin:
    phpMyAdmin 2.5.6-rc1

    I do not have that link AT ALL that I can find. I DO have the "Data Dictionary" link - Is the "Edit PDF pages" link in mine missing because my host has not enabled that functionality? Or is it no longer available in the version I am using?

    Or am I just blind and not seeing it?

    rgds
    Kilt
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    300
    Rep Power
    11
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2004
    Location
    Oslo, Norway
    Posts
    120
    Rep Power
    11
    Great tutorial. I learned alot.
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    2
    Rep Power
    0
    Nice article. This data relation only works if you add data using phpmyadmin? Any idea when MySQL will get something like that?

IMN logo majestic logo threadwatch logo seochat tools logo