Butch Evans wrote:
> My question/issue/source of discomfort is the move from MyISAM to > InnoDB. Is there a quick/easy HOW-TO on this? I read through the docs > on Mysql's website, but just don't feel comfortable doing it without > someone "watching", to give me a hand to hold onto if needed. Butch, depending on the size of your database it is a totally painful operation. Especially if you data is in good shape. So: - make sure your mysql server has innodb enabled and has room to spare for the tablespace (the ibdata files). - shut down your mta and all dbmail daemons. - run dbmail-maintenance with all checks and fixes enabled. - dump your data into a backupfile - load your data into a test database (dbmailtest) convert your tables in the test database: --------------<cut>----------------- # convert dbmail-myisam to dbmail-innodb (1.2 version) # alter table aliases type=innodb; alter table mailboxes type=innodb; alter table messageblks type=innodb; alter table messages type=innodb; alter table users type=innodb; alter table mailboxes add foreign key (owner_idnr) references users(user_idnr) on delete cascade on update cascade; alter table messages add foreign key (mailbox_idnr) references mailboxes(mailbox_idnr) on delete cascade on update cascade; alter table messageblks add foreign key (message_idnr) references messages(message_idnr) on delete cascade on update cascade; --------------<cut>----------------- and if that all works, fire this conversion sql at your production database, restart the daemons and your mta. et voila! -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
