Simon wrote:

> Good point. Im starting to look into moving to innodb tables, but will
> save the actual upgrade until a server upgrade in Jan/Feb of next year
> :) . Any good references to start here?

Read section 15.7.2 in the mysql manual.

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;



-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl

Reply via email to