On Thursday 27 March 2003 14:22, Sohail Hasan wrote: > I am running mysql 4.0.12 on both the master and slave servers. I am > facing the same problem with a slight variation. When I am trying to > import my database dump on the master the replication fails and slave > thread exits with the following error in the hostname.err file on the > slave: > > ERROR: 1005 Can't create table './cms/category.frm' (errno: 150)030327 > 11:36:01 Slave: error 'Can't create table './cms/category.frm' (errno: > 150)' on query 'CREATE TABLE category ( CATEGORYID int(10) unsigned NOT > NULL default '0', PARENTCATEGORYID int(10) unsigned default NULL, > NAME varchar(255) binary NOT NULL default '', FULLNAME blob NOT NULL,
See: the error 150 is: [EMAIL PROTECTED] egor]$ perror 150 150 = Foreign key constraint is incorrectly formed -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]