move database error 1005 on MySql

Discussion in 'Server Operation' started by provell, Jun 11, 2007.

  1. provell

    provell New Member

    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
     
    Last edited: Jun 11, 2007
  2. provell

    provell New Member

    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.:confused:

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

    Thanks in advance.

    Rgds Edo
     
  3. falko

    falko Super Moderator ISPConfig Developer

Share This Page