Paul, I have been modifying the 2_2-3_0.sql as you suggested. Almost there, it is a struggle to get all foreign keys right.
I have read the UPGRADING doc but please clarify: on old host: I backup first, then apply my modified 2_2-3_0.sql, and then I use mysqldump to transfer to the new host. on new host: dbmail-util -by dbmail-util -My (many times) Is this right? Thanks, Dirce > > The problem lies in changing fields that are involved in key constraints. > > > ALTER TABLE dbmail_acl MODIFY COLUMN user_id BIGINT(20) UNSIGNED DEFAULT > 0 NOT NULL; > > doesn't work because in your system dbmail_users.user_id is defined as a > BIGINT(21) the definition on both ends of a foreign key need to be > consistent.s > > In dbmail-2 we didn't specify the field with and just used BIGINT > UNSIGNED, which led to different fields with on different platforms. > Which is why we've switched to an explicit BIGINT(20) > > In your case you need to modify the 2_2-3_0 script and: > > - drop all foreign keys that cause trouble (see fix_foreign_keys for the > syntax) > - do all that is currently in 2_2-3_0 > - re-add the foreign keys previously dropped > > Always restart from a clean database: > > 1. mysqldump -d --opt dbmail > test.sql > 2. mysqladmin create test > 3. mysql test < test.sql > 4. mysql test < 2_2-3_0.sql > 5. in case of error edit 2_2-3_0.sql and go to 3. > > When you succeed doing this without errors, try it *with* data: > > 1. mysqldump --opt dbmail > test.sql > .... > > > > > > -- > ________________________________________________________________ > 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
