right now i'm using myisam as a database engine but i'm interested in using innodb now because i need foreign key support. however, when i got through phpmyadmin to try and change it i'm told that innodb is disabled for my mysql server... so i thought maybe i had to upgrade my service, but when i go through the host my site control panel and look at my mysql database info, under the upgrade section i'm told that there is no upgrade available for me. i'm slightly confused. i'm totally new to all of this (i'm just teaching myself as i go along) so any input would be great, thanks.

k.

Hello,
PHPMyAdmin can by quirky, and gave me trouble when I wanted to switch my tables over to InnoDB. I have worked with many HMS MySQL servers, and all have come with InnoDB. HMS does not charge extra for InnoDB, so if it is disabled on your server, I'm sure they would be glad to enable it, or move you to another MySQL server for no extra charge.

thanks so much!