mysql help...
- Started
- Last post
- 8 Responses
- foreign
hia,
i'm using msqlyog to set up a database. i've created the database and tables, set up the indexes. when i try to set up the foreign keys i get a "Table does not have InnoDB...". I know you need to set the table type as InnoDB to manage relationships in sqlyog...
i've dropped the database and recreated everything selecting InnoDB as table type. but everytime i go to set up the foreign keys it gives the same error. it keeps resetting the table types as myISAM.
anyone have any ideas on how i can get this to work?
- mirola0
Make sure the db server you have installed actually supports innodb. are you running v4.1?
- foreign0
yeah, v4.1... i managed to figure out that innodb is disabled ( i'm using appserv: php/mysql package ). don't know why it's disabled? don't know how to enable it? i've downloaded a standalone mysql installation, but i'm having trouble with the configuration.
- Jaline0
I'm not sure how to help you, but I offer my support. I once spent two days trying to figure one little thing out, and I still haven't been able to get it to work.
By it, I mean this:
http://www.sproutliner.com/
- foreign0
i've never had any difficulties like this before, but then i haven't really created and worked with complex databases before. i've learned more about mysql in the last few hours than ever before... anyone know why innodb isn't enabled in my mysql/appserv installation; or know how to enable it manually?
- cosmo0
Do you have access to the mysql configuration? If so you can probably enbale innodb.
- foreign0
yeah, thanks cosmo... that's what i was looking for.
- cosmo0
awesome, let us know if it works out.
- foreign0
finally got it going.
cheers.