On Thursday 03 April 2003 12:40, Ian Hartas wrote:
> >Description:
>
> I have a database schema .sql file which is accepted when run with
> MyISAM tables. If I change the tables to be type = InnoDB, then it fails
> with the error message:
>
> mysql -u ts -p hbs <schema_mysql.sql
> ERROR 1005 at line 54: Can't create table './hbs/#sql-34ef_f.frm' (errno:
> 150)
Your foreign key definition is not correctly formed:
http://www.mysql.com/doc/en/SEC463.html
> >How-To-Repeat:
>
> Save this text as schema_mysql.sql and run it as noted in the
> description line. database called 'hbs', user called 'ts'
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [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]
