Hi There, I am running MyISAM tables in mysql 4.1 with dbmail 2.0.9-1 on debian sarge. I am reaching a 4GB limit on the messageblks table and am going to move from MyISAM to innodb tables. As instructed i should do the following:
set unique_checks=0; alter table dbmail_users type=innodb; alter table dbmail_mailboxes type=innodb; alter table dbmail_messages type=innodb; alter table dbmail_messageblks type=innodb; ... etc ... set unique_checks=1; This seems to have worked fine on my dev server, shutting down dbmail before doing so... My question is: Is there any small tweaks needed within mysql before doing this? Thanks Simon