Thanks in advance - here is the information: Old schema:
-- MySQL dump 10.11 -- -- Host: localhost Database: dbmail -- ------------------------------------------------------ -- Server version 5.0.45 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `dbmail_acl` -- CREATE TABLE `dbmail_acl` ( `user_id` bigint(21) NOT NULL, `mailbox_id` bigint(21) NOT NULL, `lookup_flag` tinyint(1) NOT NULL default '0', `read_flag` tinyint(1) NOT NULL default '0', `seen_flag` tinyint(1) NOT NULL default '0', `write_flag` tinyint(1) NOT NULL default '0', `insert_flag` tinyint(1) NOT NULL default '0', `post_flag` tinyint(1) NOT NULL default '0', `create_flag` tinyint(1) NOT NULL default '0', `delete_flag` tinyint(1) NOT NULL default '0', `administer_flag` tinyint(1) NOT NULL default '0', PRIMARY KEY (`user_id`,`mailbox_id`), KEY `user_id_index` (`user_id`), KEY `mailbox_id_index` (`mailbox_id`), CONSTRAINT `dbmail_acl_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `dbmail_acl_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_aliases` -- CREATE TABLE `dbmail_aliases` ( `alias_idnr` bigint(21) NOT NULL auto_increment, `alias` varchar(100) NOT NULL default '', `deliver_to` varchar(250) NOT NULL default '', `client_idnr` bigint(21) NOT NULL default '0', PRIMARY KEY (`alias_idnr`), KEY `alias_index` (`alias`), KEY `client_idnr_index` (`client_idnr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_auto_notifications` -- CREATE TABLE `dbmail_auto_notifications` ( `user_idnr` bigint(21) NOT NULL, `notify_address` varchar(100) NOT NULL, KEY `user_idnr_index` (`user_idnr`), CONSTRAINT `dbmail_auto_notifications_ibfk_1` FOREIGN KEY (`user_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_auto_replies` -- CREATE TABLE `dbmail_auto_replies` ( `user_idnr` bigint(21) NOT NULL default '0', `start_date` datetime NOT NULL, `stop_date` datetime NOT NULL, `reply_body` mediumtext, KEY `user_idnr_index` (`user_idnr`), CONSTRAINT `dbmail_auto_replies_ibfk_1` FOREIGN KEY (`user_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_ccfield` -- CREATE TABLE `dbmail_ccfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `ccname` varchar(100) NOT NULL default '', `ccaddr` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_ccfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_datefield` -- CREATE TABLE `dbmail_datefield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `datefield` datetime NOT NULL default '1970-01-01 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`datefield`), CONSTRAINT `dbmail_datefield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_envelope` -- CREATE TABLE `dbmail_envelope` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `envelope` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_fromfield` -- CREATE TABLE `dbmail_fromfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `fromname` varchar(100) NOT NULL default '', `fromaddr` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_fromfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_headername` -- CREATE TABLE `dbmail_headername` ( `id` bigint(20) NOT NULL auto_increment, `headername` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `headername` (`headername`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_headervalue` -- CREATE TABLE `dbmail_headervalue` ( `headername_id` bigint(20) NOT NULL, `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `headervalue` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), UNIQUE KEY `physmessage_id_2` (`physmessage_id`,`headername_id`,`headervalue`(255)), KEY `headername_id` (`headername_id`), KEY `physmessage_id_3` (`physmessage_id`), CONSTRAINT `dbmail_headervalue_ibfk_1` FOREIGN KEY (`headername_id`) REFERENCES `dbmail_headername` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `dbmail_headervalue_ibfk_2` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_mailboxes` -- CREATE TABLE `dbmail_mailboxes` ( `mailbox_idnr` bigint(21) NOT NULL auto_increment, `owner_idnr` bigint(21) NOT NULL default '0', `name` varchar(100) NOT NULL default '', `seen_flag` tinyint(1) NOT NULL default '0', `answered_flag` tinyint(1) NOT NULL default '0', `deleted_flag` tinyint(1) NOT NULL default '0', `flagged_flag` tinyint(1) NOT NULL default '0', `recent_flag` tinyint(1) NOT NULL default '0', `draft_flag` tinyint(1) NOT NULL default '0', `no_inferiors` tinyint(1) NOT NULL default '0', `no_select` tinyint(1) NOT NULL default '0', `permission` tinyint(1) default '2', PRIMARY KEY (`mailbox_idnr`), UNIQUE KEY `owner_idnr_name_index` (`owner_idnr`,`name`), KEY `name_index` (`name`), KEY `owner_idnr_index` (`owner_idnr`), CONSTRAINT `dbmail_mailboxes_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_messageblks` -- CREATE TABLE `dbmail_messageblks` ( `messageblk_idnr` bigint(21) NOT NULL auto_increment, `physmessage_id` bigint(21) NOT NULL default '0', `messageblk` longblob NOT NULL, `blocksize` bigint(21) NOT NULL default '0', `is_header` tinyint(1) NOT NULL default '0', PRIMARY KEY (`messageblk_idnr`), KEY `physmessage_id_index` (`physmessage_id`), KEY `physmessage_id_is_header_index` (`physmessage_id`,`is_header`), CONSTRAINT `dbmail_messageblks_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_messages` -- CREATE TABLE `dbmail_messages` ( `message_idnr` bigint(21) NOT NULL auto_increment, `mailbox_idnr` bigint(21) NOT NULL default '0', `physmessage_id` bigint(21) NOT NULL default '0', `seen_flag` tinyint(1) NOT NULL default '0', `answered_flag` tinyint(1) NOT NULL default '0', `deleted_flag` tinyint(1) NOT NULL default '0', `flagged_flag` tinyint(1) NOT NULL default '0', `recent_flag` tinyint(1) NOT NULL default '0', `draft_flag` tinyint(1) NOT NULL default '0', `unique_id` varchar(70) NOT NULL default '', `status` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`message_idnr`), KEY `physmessage_id_index` (`physmessage_id`), KEY `mailbox_idnr_index` (`mailbox_idnr`), KEY `seen_flag_index` (`seen_flag`), KEY `unique_id_index` (`unique_id`), KEY `status_index` (`status`), KEY `mailbox_status` (`mailbox_idnr`,`status`), CONSTRAINT `dbmail_messages_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `dbmail_messages_ibfk_2` FOREIGN KEY (`mailbox_idnr`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_pbsp` -- CREATE TABLE `dbmail_pbsp` ( `idnr` bigint(21) NOT NULL auto_increment, `since` datetime NOT NULL default '0000-00-00 00:00:00', `ipnumber` varchar(40) NOT NULL, PRIMARY KEY (`idnr`), UNIQUE KEY `ipnumber_index` (`ipnumber`), KEY `since_index` (`since`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_physmessage` -- CREATE TABLE `dbmail_physmessage` ( `id` bigint(21) NOT NULL auto_increment, `messagesize` bigint(21) NOT NULL default '0', `rfcsize` bigint(21) NOT NULL default '0', `internal_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_referencesfield` -- CREATE TABLE `dbmail_referencesfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `referencesfield` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`referencesfield`), CONSTRAINT `dbmail_referencesfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_replycache` -- CREATE TABLE `dbmail_replycache` ( `to_addr` varchar(100) NOT NULL default '', `from_addr` varchar(100) NOT NULL default '', `handle` varchar(100) NOT NULL default '', `lastseen` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `replycache_1` (`to_addr`,`from_addr`,`handle`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_replytofield` -- CREATE TABLE `dbmail_replytofield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `replytoname` varchar(100) NOT NULL default '', `replytoaddr` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_replytofield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_sievescripts` -- CREATE TABLE `dbmail_sievescripts` ( `owner_idnr` bigint(21) NOT NULL default '0', `name` varchar(100) NOT NULL, `script` text, `active` tinyint(1) NOT NULL default '0', KEY `name` (`name`), KEY `owner_idnr` (`owner_idnr`), KEY `owner_idnr_2` (`owner_idnr`,`name`), CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_subjectfield` -- CREATE TABLE `dbmail_subjectfield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `subjectfield` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`subjectfield`), CONSTRAINT `dbmail_subjectfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_subscription` -- CREATE TABLE `dbmail_subscription` ( `user_id` bigint(21) NOT NULL default '0', `mailbox_id` bigint(21) NOT NULL, PRIMARY KEY (`user_id`,`mailbox_id`), KEY `user_id_index` (`user_id`), KEY `mailbox_id_index` (`mailbox_id`), CONSTRAINT `dbmail_subscription_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `dbmail_subscription_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_tofield` -- CREATE TABLE `dbmail_tofield` ( `physmessage_id` bigint(20) NOT NULL, `id` bigint(20) NOT NULL auto_increment, `toname` varchar(100) NOT NULL default '', `toaddr` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`), CONSTRAINT `dbmail_tofield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_usermap` -- CREATE TABLE `dbmail_usermap` ( `login` varchar(100) NOT NULL, `sock_allow` varchar(100) NOT NULL, `sock_deny` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, UNIQUE KEY `usermap_idx_1` (`login`,`sock_allow`,`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `dbmail_users` -- CREATE TABLE `dbmail_users` ( `user_idnr` bigint(21) NOT NULL auto_increment, `userid` varchar(100) NOT NULL default '', `passwd` varchar(34) NOT NULL default '', `client_idnr` bigint(21) NOT NULL default '0', `maxmail_size` bigint(21) NOT NULL default '0', `curmail_size` bigint(21) NOT NULL default '0', `maxsieve_size` bigint(20) NOT NULL default '0', `cursieve_size` bigint(20) NOT NULL default '0', `encryption_type` varchar(20) NOT NULL default '', `last_login` datetime NOT NULL default '1979-11-03 22:05:58', PRIMARY KEY (`user_idnr`), UNIQUE KEY `userid_index` (`userid`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(32) NOT NULL, `access` int(10) unsigned default NULL, `data` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2012-02-08 21:19:13 ********************************************** Console output when I run mysql --verbose dbmail < 2_2-3_0.mysql -------------- SET FOREIGN_KEY_CHECKS=0 -------------- -------------- ALTER DATABASE CHARACTER SET utf8 -------------- -------------- BEGIN -------------- -------------- DELETE FROM dbmail_referencesfield -------------- -------------- COMMIT -------------- -------------- DROP TABLE IF EXISTS dbmail_ccfield -------------- -------------- DROP TABLE IF EXISTS dbmail_datefield -------------- -------------- DROP TABLE IF EXISTS dbmail_fromfield -------------- -------------- DROP TABLE IF EXISTS dbmail_replytofield -------------- -------------- DROP TABLE IF EXISTS dbmail_subjectfield -------------- -------------- DROP TABLE IF EXISTS dbmail_tofield -------------- -------------- ALTER TABLE dbmail_acl MODIFY COLUMN user_id BIGINT(20) UNSIGNED DEFAULT 0 NOT NULL -------------- ERROR 1025 (HY000) at line 26: Error on rename of './dbmail/#sql-9dd_1ac2' to './dbmail/dbmail_acl' (errno: 150) ]0;r...@smg.dirce2.lab:/var/tmpr...@smg.dirce2.lab:/var/tmp[148] exit exit ***************************************************** Here is what I was attempting to do: to remove each constraint, per table. Now I also found a script under: dbmail/dbmail-3.0.0-rc1/sql/mysql/fix_foreign_keys.mysql I think this script does what I was trying to do, but it is not working yet. I am trying to figure out how it can work for me. mysql dbmail -f < fix_foreign_keys.mysql output: ERROR 1025 (HY000) at line 42: Error on rename of './dbmail/dbmail_mailboxes' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 43: Error on rename of './dbmail/dbmail_mailboxes' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 45: Error on rename of './dbmail/dbmail_mailboxes' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 50: Error on rename of './dbmail/dbmail_subscription' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 51: Error on rename of './dbmail/dbmail_subscription' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 54: Error on rename of './dbmail/dbmail_subscription' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 61: Error on rename of './dbmail/dbmail_acl' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 62: Error on rename of './dbmail/dbmail_acl' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 63: Error on rename of './dbmail/dbmail_acl' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 64: Error on rename of './dbmail/dbmail_acl' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 65: Error on rename of './dbmail/dbmail_acl' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1005 (HY000) at line 66: Can't create table './dbmail/#sql-9dd_1dc1.frm' (errno: 150) ERROR 1005 (HY000) at line 68: Can't create table './dbmail/#sql-9dd_1dc1.frm' (errno: 150) ERROR 1025 (HY000) at line 72: Error on rename of './dbmail/dbmail_messages' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 73: Error on rename of './dbmail/dbmail_messages' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 76: Error on rename of './dbmail/dbmail_messages' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 83: Error on rename of './dbmail/dbmail_messageblks' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 85: Error on rename of './dbmail/dbmail_messageblks' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 90: Error on rename of './dbmail/dbmail_sievescripts' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1025 (HY000) at line 92: Error on rename of './dbmail/dbmail_sievescripts' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1146 (42S02) at line 97: Table 'dbmail.dbmail_header' doesn't exist ERROR 1146 (42S02) at line 98: Table 'dbmail.dbmail_header' doesn't exist ERROR 1146 (42S02) at line 99: Table 'dbmail.dbmail_header' doesn't exist ERROR 1146 (42S02) at line 100: Table 'dbmail.dbmail_header' doesn't exist ERROR 1146 (42S02) at line 101: Table 'dbmail.dbmail_header' doesn't exist ERROR 1146 (42S02) at line 102: Table 'dbmail.dbmail_header' doesn't exist ERROR 1146 (42S02) at line 103: Table 'dbmail.dbmail_header' doesn't exist ERROR 1146 (42S02) at line 106: Table 'dbmail.dbmail_subjectfield' doesn't exist ERROR 1146 (42S02) at line 107: Table 'dbmail.dbmail_subjectfield' doesn't exist ERROR 1146 (42S02) at line 108: Table 'dbmail.dbmail_subjectfield' doesn't exist ERROR 1146 (42S02) at line 112: Table 'dbmail.dbmail_datefield' doesn't exist ERROR 1146 (42S02) at line 113: Table 'dbmail.dbmail_datefield' doesn't exist ERROR 1146 (42S02) at line 114: Table 'dbmail.dbmail_datefield' doesn't exist ERROR 1025 (HY000) at line 119: Error on rename of './dbmail/dbmail_referencesfield' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ERROR 1146 (42S02) at line 124: Table 'dbmail.dbmail_fromfield' doesn't exist ERROR 1146 (42S02) at line 125: Table 'dbmail.dbmail_fromfield' doesn't exist ERROR 1146 (42S02) at line 126: Table 'dbmail.dbmail_fromfield' doesn't exist ERROR 1146 (42S02) at line 130: Table 'dbmail.dbmail_tofield' doesn't exist ERROR 1146 (42S02) at line 131: Table 'dbmail.dbmail_tofield' doesn't exist ERROR 1146 (42S02) at line 132: Table 'dbmail.dbmail_tofield' doesn't exist ERROR 1146 (42S02) at line 136: Table 'dbmail.dbmail_replytofield' doesn't exist ERROR 1146 (42S02) at line 137: Table 'dbmail.dbmail_replytofield' doesn't exist ERROR 1146 (42S02) at line 138: Table 'dbmail.dbmail_replytofield' doesn't exist ERROR 1146 (42S02) at line 142: Table 'dbmail.dbmail_ccfield' doesn't exist ERROR 1146 (42S02) at line 143: Table 'dbmail.dbmail_ccfield' doesn't exist ERROR 1146 (42S02) at line 144: Table 'dbmail.dbmail_ccfield' doesn't exist ERROR 1025 (HY000) at line 149: Error on rename of './dbmail/dbmail_envelope' to './dbmail/#sql2-9dd-1dc1' (errno: 152) ]0; ********************************* > On 02/08/2012 07:46 PM, drsyst...@globalcerts.net wrote: >> Hi, >> I am running the script >> /var/lib/mysql/dbmail[157] mysql < 2_2-3_0.mysql > which is incorrect, as you found out already. >> ERROR 1025 (HY000) at line 68: Error on rename of >> './dbmail/#sql-9dd_357e' >> to './dbmail/dbmail_users' (errno: 150) > Was that the first message? Please increase your verbosity and help others help you: > - sql dump of old schema > - full console log of schema migration run > - your my.cnf (you did that already, assuming it was complete). >> I have been fixing it one db at a time by doing: > I hope you mean table, rather then db. > I'm guessing here, but I'm beginning to suspect your 2.2 schema is different from the vanilla 2.2 schema. > -- > ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin > * Premium Hosting Services and Web Application Consultancy * > www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 > ________________________________________________________________ _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail