Well, you can change the tables live and add the key constraints, etc.
But I wonder if that doesn´t end up in desaster for some reason.
I would dump the database without the table structures, just the data.
Empty the database, create the tables with the scripts from dbmail tar ball.
Make sure
Am 05.09.2011 11:20, schrieb Simon:
On Tue, Aug 30, 2011 at 7:58 PM, Igor Živković i...@oglasnik.hr wrote:
On 08/29/2011 11:48 PM, Simon wrote:
On 30/08/2011, at 9:42 AM, Reindl Harald wrote:
your innodb-settings sucks
this should not be so slow
on our 15 GB dbmail-database dbmail-util
On Mon, Sep 5, 2011 at 9:54 PM, Reindl Harald h.rei...@thelounge.net wrote:
this is very bad, you should really take more care of what your setups
are looking like before going in production!
Tell me about it. I ran our migration from mysql4 to mysql 5 (where we
are now) 3 times with
On 08/29/2011 11:48 PM, Simon wrote:
On 30/08/2011, at 9:42 AM, Reindl Harald wrote:
your innodb-settings sucks
this should not be so slow
on our 15 GB dbmail-database dbmail-util needs only 5 minutes
and there is normal access to anything while it tuns
how much mameory has your box and
Hi There,
We are using dbmail 2.2.17 on debian squeeze connected to a mysql
5.1.49-3 server (replicated to another 5.1.49-3 server ). There is
around 70GB in the dbmail_messageblks table. Each night (morning) at
3am we run /usr/local/sbin/dbmail-util -ay which results in a
process that takes
your innodb-settings sucks
this should not be so slow
on our 15 GB dbmail-database dbmail-util needs only 5 minutes
and there is normal access to anything while it tuns
how much mameory has your box and what are your mysql-settings
Am 29.08.2011 23:31, schrieb Simon:
Hi There,
We are using
On 30/08/2011, at 9:42 AM, Reindl Harald wrote:
your innodb-settings sucks
this should not be so slow
on our 15 GB dbmail-database dbmail-util needs only 5 minutes
and there is normal access to anything while it tuns
how much mameory has your box and what are your mysql-settings
Thanks
Am 29.08.2011 23:48, schrieb Simon:
On 30/08/2011, at 9:42 AM, Reindl Harald wrote:
your innodb-settings sucks
this should not be so slow
on our 15 GB dbmail-database dbmail-util needs only 5 minutes
and there is normal access to anything while it tuns
how much mameory has your box