SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Member atem451's Avatar
    Join Date
    May 2001
    Location
    Berlin
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Tool needed

    Maybe I ask at wrong place, but does anybody know a tool for MySQL, which is able to give me a graphical view over all tables like in Access, with the relations between the tables?

    Thank you.
    Footbag: Spread the Spirit

  2. #2
    Your daddy. WALoeIII's Avatar
    Join Date
    Apr 2001
    Location
    USA
    Posts
    526
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    There is a good one called phpMyAdmin, and you can get it from phpwizard.net.

  3. #3
    SitePoint Member atem451's Avatar
    Join Date
    May 2001
    Location
    Berlin
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    I like that one, but it's not what I need

    I know PHPMyAdmin, but that's not what I need.

    I need a tool some Software, which can display my Tables in the way Access does (the english word for that option in Access should be 'relations' or something like that.).
    I need to see show the relations of all tables (for example the the KEYS connected by lines) to each other on one Screen; Printable and as a GRAPHIC!
    Footbag: Spread the Spirit

  4. #4
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You could use MyODBC and link the tables into Access if you want. Basically install myOdbc

    http://mysql.he.net/downloads/api-myodbc.html


    Then set up a new data source using the myODBC driver and specify the server username and password then you can simply link the tables into Access
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  5. #5
    SitePoint Member atem451's Avatar
    Join Date
    May 2001
    Location
    Berlin
    Posts
    24
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access s****

    yes, I already did that, but everytime you alter your Table, you have to etablish a new ODBC-connection to this DB, and then you have to do all the relations in this graphic-mode again (which can be a lot of work..)
    Footbag: Spread the Spirit

  6. #6
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Unfortunately, MySQL is not robust enough to rpovide that type of service. I am 99.9% sure there is no piece of software that is gonna read in a MySQL database and create a visual schematic of tables and their relations for you. You might think about moving to a more commercial product than MySQL for this, Sybase has Powerbuilder, Oracle has some software that does this, and of course Access(which by no means is robust) have thsi type of feature.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  7. #7
    SitePoint Member
    Join Date
    Jun 2001
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    This may help....

    I think Mascon may be what you are searching for...you can check it out at:

    http://www.scibit.com

    They have a free version available as well for download. I'm not sure if they visually show the relations between the tables, but it may be worth a look.

    Cheers.

  8. #8
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Excellent link anthro, thanks
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  9. #9
    SitePoint Member hsfournier's Avatar
    Join Date
    Apr 2001
    Location
    Canada
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The tool I would suggest is mySQL Front, it doesn't show relationships like in Access, but it does show everything else in the GUI in a way very similar to Access. From my point of view it is the best GUI for mySQL, I use it every day.

    You can get it at www.mysqlfront.de

    Good luck
    Heidi Fournier

  10. #10
    Talk to the /dev/null Theiggsta's Avatar
    Join Date
    Mar 2001
    Location
    Tampa, FL
    Posts
    376
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I prefer mysqlfront over mascon (one reason is because its FREE )

    and the new version is out with new features and bugfixes, I highly suggest it for the newbie.
    Aaron "Theiggsta" Kalin
    Pixel Martini
    Ruby and Rails Developer


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •