Page 1 of 1

sqlyog and Innodb!

Posted: Mon Aug 18, 2003 4:39 pm
by maldar
Hi ,

I want to manage relationship between my tables,so table type must be
InnoDB.but when I want to manage tables relationship I recieve this error message :

"The selected table does not have an InnoDB table handler. you can not manage relationship for the table"
why ?????

also I can not change my table type to InnoDB.(in table creation time or with right-click on its name and change its type to InnoDB)
if I must install or configure everything???

Please help me.

Re: sqlyog and Innodb!

Posted: Mon Aug 18, 2003 4:43 pm
by jason
maldar wrote::?:
Hi ,

I want to manage relationship between my tables,so table type must be
InnoDB.but when I want to manage tables relationship I recieve this error message :

"The selected table does not have an InnoDB table handler. you can not manage relationship for the table"

why ?????

also I can not change my table type to InnoDB.(in table creation time or with right-click on its name and change its type to InnoDB)
if I must install or configure everything???

Please help me.
Well, I think you answered your first question. If you cannot set your table type to InnoDB, you obviously can't manage table relationships.

I would suggest installing the latest MySQL, MySQL 4 as this has InnoDB installed by default.

Posted: Tue Aug 19, 2003 12:36 pm
by BDKR
Jason is right. I've done a lot of work with Innodb. You must first have a version of MySQL that supports it. If you are using the 3.23.xx series, make sure it's a Max version. Otherwise, use MySQL 4.0 and above as Jason stated.

Cheers,
BDKR

more detail please

Posted: Fri Aug 29, 2003 11:02 pm
by maldar
Thanks to Jason and BDKR,

I did that (install mysql 4.0 and 4.1) but I recieve that message again and could not manage tables relationship

for some reason I want to use mysql 3.23.49 and want to configure InnoDB manually to manage my table relationship in SQLYog .
because of I am beginnig with work on configuration files Please help me in more details (please step-by-step) . Thanks a lot.

Posted: Sun Aug 31, 2003 8:46 pm
by JAM
Have no idea whatsoever ;) but this might help.
http://www.mysql.com/doc/en/InnoDB_in_MySQL_3.23.html

Posted: Mon Sep 01, 2003 12:47 am
by maldar
yes,it was useful. but i want install instruction for windows platform.I can't find it .

Posted: Mon Sep 01, 2003 5:25 am
by JAM
''To use InnoDB tables in MySQL-Max-3.23 you must specify configuration parameters in the [mysqld] section of the configuration file `my.cnf', or on Windows optionally in `my.ini'.''

Sorry, thought that would lead you to some useful reading.

Re: sqlyog and Innodb!

Posted: Mon Sep 01, 2003 8:00 am
by BDKR
maldar wrote:Hi ,

"The selected table does not have an InnoDB table handler. you can not manage relationship for the table"
why ?????
It allways blows me away how much we learn when we go back and look at the error message a second or third time! This error message says it all. If the table wasn't created as a innodb table in first place. Recreate the table as an innodb then try.

The manual explains how to do it. There is also a mechanism provided by MySQLAdmin. Do read the section on Innodb setup and pay attention to configuration instructions (as in my.cnf). It can be done with the manual alone. I had a little trouble with it too, but I got it figured and used it in a mission critical business situation for over a year.

Another clue for you may be to look at the output of your existing database via a mysqldump. Look in particular at the last line of the table definition.

As for "detailed instructions", you're barking up the wrong tree here. There is information out there and most of us use the existing sources. You can't expect people to drop everything and write such stuff for you without compensation. Besides, learning how to sift the needed details out of manuals (however poorly written) will be a big boon for you as a developer or admin.

Cheers,
BDKR

Posted: Mon Sep 01, 2003 8:06 am
by BDKR
Perhaps I better explain something else. There is a concept in MySQL of table handlers. These 'handlers' work with the differing table types provided. Those are MyISAM, BDB, and InnoDB. They all provide slightly different feature sets. The 'handlers' are like abstraction layers for working with a particular table type.

:wink:

Cheers,
BDKR