> I've been running MySQL 4.0.x on a RH9 machine for some months and everything
> was fine. I could create tables of type InnoDB and define FOREIGN KEY's.... all
> was well.
> A few days ago it does not let me create tables with foreign keys anymore.... it
> says something like "unable to create /databasename/tablename"...
> If I remove the FOREIGN KEY constraint it accepts de table creation.
You have incorrect foreign key definition. Use SHOW INNODB STATUS command to see more
detailed error message.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net