Page 1 of 1

phpMyAdmin's designer interface

PostPosted: 25. November 2011 10:35
by chandecweng
Hi everyone,

When I go to phpmyadmin designer interface, I can not use the relationship join(graphical join(eg: many to one).

Can provide me the solution to fix it?

Thanks for your times (<.>)

Re: phpMyAdmin's designer interface

PostPosted: 25. November 2011 23:17
by JonB
Hi -

Although some one here may be able to help or give an answer, this is really a phpMyAdmin topic, no one at XAMPP had any part in creating that interface.

You might try over here:
http://sourceforge.net/projects/phpmyad ... orum/72909

You also could try the free tool from Oracle/MySQL - MySQL Workbench - it has a full complement of tools for creating/designing databases including EER diagramming, 1-to-1, 1-to-many and foreign keys support for InnoDB engine. Runs on basically all platforms and has Python add-ins (such as diagramming many-to-many) Also does import/export, create drop etc. You can also create from design/schema, update in either direction - ummm 'very nice'.

http://www.mysql.com/products/workbench/

Good Luck
8)

Re: phpMyAdmin's designer interface

PostPosted: 26. November 2011 09:56
by chandecweng
JonB wrote:Hi -

Although some one here may be able to help or give an answer, this is really a phpMyAdmin topic, no one at XAMPP had any part in creating that interface.

You might try over here:
http://sourceforge.net/projects/phpmyad ... orum/72909

You also could try the free tool from Oracle/MySQL - MySQL Workbench - it has a full complement of tools for creating/designing databases including EER diagramming, 1-to-1, 1-to-many and foreign keys support for InnoDB engine. Runs on basically all platforms and has Python add-ins (such as diagramming many-to-many) Also does import/export, create drop etc. You can also create from design/schema, update in either direction - ummm 'very nice'.

http://www.mysql.com/products/workbench/

Good Luck
8)



Hi,thanks for your info.
If i want to use mysql workbench, do I have to download the whole installer package. (Mysql installer)
I am using xampp and want to use with apache.

after I had download the workbench alone, I try to apply "Administering a MySQL Server" by follow the documentation, the wizard skip the Management and OS and SSH Configuration section,then for the window management section, I want select the service from the drop down list,it is empty.
I can not forward after this

Thanks for your times

Re: phpMyAdmin's designer interface

PostPosted: 26. November 2011 18:39
by JonB
Ok -

I'm 'guessing' at the moment -

You will have to have your MySQL server started in XAMPP before you can use MySQL Workbench --


Good Luck