Hello, I try to set up replication and woulkd like to export my master with mysqldump. The import fails with ERROR 1005 (HY000) (errno 150)when trying to import the dump on the slave. The create-state which causes the error is:
CREATE TABLE fond4client ( id int(11) NOT NULL auto_increment, fond_id int(11) NOT NULL default '0', client_id int(11) NOT NULL default '0', price_buy double NOT NULL default '-1', price_sell double NOT NULL default '-1', import_history_id int(11) default NULL, active char(1) NOT NULL default '', PRIMARY KEY (id), KEY fond4client_import_hist_id_idx (import_history_id), KEY fond4client_client_id_idx (client_id), KEY fond4client_active_idx (active), CONSTRAINT `0_34` FOREIGN KEY (`import_history_id`) REFERENCES `import_history` (`id`), CONSTRAINT `0_35` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`) ) TYPE=InnoDB; master is: 4.0.17 slave: 4.1.7 Trying to insert the dump on another 4.0.17 fails too. Any hints out there? Regards Jochen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]