One thing to watch out for is the innodb_data_file_path sting. That controls how big individual innodb files are allowed to get, and if they're allowed to grow. The default on my system (Gentoo 2006.0) was an unreasonably small number, and importing my initial load of messages would always fail shortly after starting, with a bunch of strange disconnection errors in the log.
.....jurgen On 10/07/06, Simon <[EMAIL PROTECTED]> wrote:
On 7/10/06, Paul J Stevens <[EMAIL PROTECTED]> wrote: > Simon, > > Simon wrote: > > set unique_checks=0; > > alter table dbmail_users 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? > > After doing this, you will still need to add all the foreign keys by > hand. That is not an urgent matter while you're on 2.0.x, but 2.1.x > relies on them. Thanks Paul is there instructions on doing this with dbmail?... or can you point me in the correct direction? Also: is there any my.cnf tweaks needed? THanks Simon _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- [EMAIL PROTECTED] is jurgen's gmail address. Visit http://jurgen.ca/ for more yummy goodness.
