sqlyog and Innodb!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
maldar
Forum Commoner
Posts: 49
Joined: Mon Aug 18, 2003 4:39 pm

sqlyog and Innodb!

Post 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.
jason
Site Admin
Posts: 1767
Joined: Thu Apr 18, 2002 3:14 pm
Location: Montreal, CA
Contact:

Re: sqlyog and Innodb!

Post 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.
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post 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
maldar
Forum Commoner
Posts: 49
Joined: Mon Aug 18, 2003 4:39 pm

more detail please

Post 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.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

Have no idea whatsoever ;) but this might help.
http://www.mysql.com/doc/en/InnoDB_in_MySQL_3.23.html
maldar
Forum Commoner
Posts: 49
Joined: Mon Aug 18, 2003 4:39 pm

Post by maldar »

yes,it was useful. but i want install instruction for windows platform.I can't find it .
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Re: sqlyog and Innodb!

Post 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
User avatar
BDKR
DevNet Resident
Posts: 1207
Joined: Sat Jun 08, 2002 1:24 pm
Location: Florida
Contact:

Post 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
Post Reply