"Paul West" <[EMAIL PROTECTED]> wrote:
> Here are some easy questions I hope you can answer.
> I have been creating innoDB tables in mysql, creating contraints and foreign keys
> and it
> runs swimmingly.
>
> The server I am now doing mySQL on won't allow me to create other than myISAM tables.
>
> Is it true that only innoDB tables support Foreign keys constraints?
Yes.
> Is there an alternative to FK contraints for myISAM tables?
No.
> Is there something I can configure (locally) to allow the creation of innoDB tables?
If you use 3.23 version you should install MySQL-Max and specify innodb_data_file_path
variable:
http://dev.mysql.com/doc/mysql/en/InnoDB_in_MySQL_3.23.html
>
> If what i suspect is true, that myISAM tables don't cater for FK contraints, then
> there
> usefulness is lost on me. Why have a database if you can't keep the information
> linked /
> accurate?! (I'm sure myISAM does have an upside, don't flame me ;) )
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
