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.
sqlyog and Innodb!
Moderator: General Moderators
Re: sqlyog and Innodb!
Well, I think you answered your first question. If you cannot set your table type to InnoDB, you obviously can't manage table relationships.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.
I would suggest installing the latest MySQL, MySQL 4 as this has InnoDB installed by default.
more detail please
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.
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.
Re: sqlyog and Innodb!
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.maldar wrote:Hi ,
"The selected table does not have an InnoDB table handler. you can not manage relationship for the table"
why ?????
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
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.
Cheers,
BDKR
Cheers,
BDKR