On Wed, 30 Nov 2005, Paul J Stevens wrote:
Butch, depending on the size of your database it is a totally painful operation. Especially if you data is in good shape.
Hope you meant "painless". :-) The database is ~1GB. Any ideas on how much time to convert this?
- 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)
The rest of this looks much less painless than I thought it would be reading the docs. InnoDB vs MyISAM won't be a problem with the earlier version of dbmail?
-- Butch Evans BPS Networks http://www.bpsnetworks.com/ Bernie, MO Mikrotik Certified Consultant (http://www.mikrotik.com/consultants.html)
