move database error 1005 on MySql

Hy everyone,

I am trying to move a database(used by a website) from one ispconfig server to a new ispconfig server.
As I have this done with lots of other(joomla) databases, this one gives me an error while trying to import it.
This is not a joomla database, but designed by the customer himself.

I use ISPCONFIG's backup option to make a complete backup of the websit, including the database.
Then when I use phpmyadmin on the new server again, I get an error on importing it.

Here is the error message:
SQL-query:

CREATE TABLE `tf_article` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` text NOT NULL ,
`description` text NOT NULL ,
`picture` text NOT NULL ,
`collection` int( 11 ) NOT NULL default '0',
`position` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `collection` ( `collection` ) ,
CONSTRAINT `tf_article_ibfk_1` FOREIGN KEY ( `collection` ) REFERENCES `tf_collection` ( `id` ) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE = InnoDB;


MySQL retourneerde:

#1005 - Can't create table './web8_db1/tf_article.frm' (errno: 150)



I have been googling on this problem for a while now, but without any luck.
Using some options on the export and import fields did not help me as I am no expert of MySql databases or PhpMyAdmin.

Both server run Debian/sarge and mysql 4.0.24.

If anybody has any idea, I would be verry thankfull.

Rgds Edo

 

lookes solved

Update:

I did an export with phpmyadmin instead of using ispconfig's backup.
This was a file I could import into the database.

Okee, now the website seems to be working and the database is copied.
But this means that if I use ispconfig's backup utility it is not always making the right backup of the database.

If the ISPconfig develloppers might be reading this:
Please comment on this assumpion.

Thanks in advance.

Rgds Edo

 

Please try this method to restore a database dump: http://www.howtoforge.com/faq/6_4_en.html