MySQL Administrator wont show my FOREIGN KEY relations :|
Any clues ?
[381 byte] By [Amn] at [2007-11-19 2:40:05] 
I actually can create these relations by means of writing SQL expressions when creating or altering a table, but whenever I return to view the table (Edit Table menu item), no foreign key relations are listed - the list box is empty ! This also presents a problem of deleting my existing relations, how can I do that if the program shows only an empty list !!!
Any clues ?
# 1 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
The default table type in MySQL is MyISAM that does not support foreign keys.You must use InnoDB tables.
Quoted from MySQL Reference Manual
InnoDB tables support checking of foreign key constraints.
See Section 7.5 [InnoDB], page 506. For other table types, MySQL Server does parse the
FOREIGN KEY syntax in CREATE TABLE commands, but without further action being taken.
For more info take a look in InnoDB Tables chapter in MySQL Reference Manual.
ovidiucucu at 2007-11-9 13:39:11 >
# 2 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
My table type IS InnoDB in BOTH tables referencing each other. InnoDB is installed and active. I have the integrity checking, it just doesn't show in Administrator lis box when viewing the table details. So I cannot remove existing keys :(Amn at 2007-11-9 13:40:10 >
# 3 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
Well, I'm not currently use InnoDB and MySQLAdmin, so just I can presume that if you are sure the tables are of InnoDB type and foreign keys were successfully created, it's a possible bug or not implemented yet feature in MySQLAdmin.Remove the keys like you created them: using SQL statements.
ovidiucucu at 2007-11-9 13:41:18 >
# 4 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
Thank you.Yes, i can add and remove the keys with SQL statements, I am not VERY good at them, but I have some knowledge, and the rest I can look up in the manual. It irritates me that such a praised technology as MySQL has a buggy GUI client as MySQL Administrator, and that after they discontinued Control Center...
Actually it is not the only bug in Administrator, I ve seen more than enough of those. From time to time a DLL crashes referencing NULL pointer, then, it doesn't show server parameters (just empty controls), until you restart the server and show the tab again. Dont remember, there maybe more.
Amn at 2007-11-9 13:42:13 >
# 5 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
You are welcome.Actually, I'm using MySQLFront that is an excellent GUI client.
Unforunatelly, it is also discontinued, but I hope you can still find it with a gooooogle search. ;)
ovidiucucu at 2007-11-9 13:43:21 >
# 6 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
I have it ;) It crashed once on me, I didn't like it !:) Can it create and edit indices and foreign keys ?
Thanks again !
Amn at 2007-11-9 13:44:20 >
# 7 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
I have version 2.5 and it's quite good and stable.Yes, you can create indexes in Field Editor dialog, but for foreign keys it says "coming soon", so I'm waiting for at least one little service pack saying "coming never - I'm discontinued". :D
Anyhow, I preffer using the Query Editor window and write/run SQL statements.
ovidiucucu at 2007-11-9 13:45:13 >
# 8 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
Thanks man !Well, I am not that good in writing DDF queries, only data manipulation (SELECT; INSERT; UPDATE etc)
By the way, I remember another bug in MySQL ADministrator !
When you change the collation of a table, they have a typo there saying 'OLLATE' instead of 'COLLATE' !!! :D LOL
;)
Amn at 2007-11-9 13:46:15 >
# 9 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
Rule nr. 0 of third party software: Cheaper = more buggy. We can try migrate to Oracle, for example, but I think we need some additional money. :Dovidiucucu at 2007-11-9 13:47:23 >
# 10 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
I dont agree to rule nr.0 ;)MySQL server is free itself, but the server is rock solid and ultra-fast not to mention the support and features ;)
It is the sloppy Administrator software which ruins the experience, and I dont have the time to write my own :)
Also, eMule Plus is free, OpenOffice, PHP, FireFox, Opera etc ... and they are more stable than Microsoft Internet Explorer, which is funded by billions of dollars ! :D
Amn at 2007-11-9 13:48:23 >
# 11 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
Thanks man !Well, I am not that good in writing DDF queries, only data manipulation (SELECT; INSERT; UPDATE etc)
One thing I like at MySQL is that it has a very good manual. So what's the problem? Just open it and go ahead! ;)
ovidiucucu at 2007-11-9 13:49:21 >
# 12 Re: MySQL Administrator wont show my FOREIGN KEY relations :|
Well, since I have no other choice as MySQL ADministrator behaves so bad, I WILL DO JUST THAT ! :DThanks for the discussion ;)
Amn at 2007-11-9 13:50:18 >
