#3 Restore problem - errno: 150

closed
nobody
None
5
2011-08-30
2006-01-24
Anonymous
No

Submitted by emdeex@gmail.com

trying to restore a v2.2 automysqlbackup gives a MySQL
4.1.11 error 150:

MySQL error code 150: Foreign key constraint is
incorrectly formed, on line 20

line 20:
CREATE TABLE `accountgroups` (
`groupname` char(30) NOT NULL default '',
`sectioninaccounts` int(11) NOT NULL default '0',
`pandl` tinyint(4) NOT NULL default '1',
`sequenceintb` smallint(6) NOT NULL default '0',
PRIMARY KEY (`groupname`),
KEY `SequenceInTB` (`sequenceintb`),
KEY `sectioninaccounts` (`sectioninaccounts`),
CONSTRAINT `accountgroups_ibfk_1` FOREIGN KEY
(`sectioninaccounts`) REFERENCES `accountsection`
(`sectionid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Discussion

  • Harley

    Harley - 2006-02-13

    Logged In: YES
    user_id=877945

    The only thing I can think of is that the version of MySQL
    that your are trying to restore to is different from the one
    on which the backup was created..

    Have you changed or upgraded the MySQL server?

     
  • PittaGurneyi

    PittaGurneyi - 2011-08-30

    No further information supplied. Closing it now since it is already years old and the user hasn't responded again.

     
  • PittaGurneyi

    PittaGurneyi - 2011-08-30
    • status: open --> closed
     

Log in to post a comment.