Paul J Stevens wrote:
[EMAIL PROTECTED] wrote:
Importing that much data is slow. Just copy the files for backup then
alter. Check to see if the number of rows match.
Yes, dump and reload is slow, but it will most likely still be a lot
faster than an alter command.
OK.. so the process would be:
1). Backup everything!
2). mysqldump the dbmail_messageblks table to a file
3). drop the dbmail_messageblks table
4). recreate the dbmail_messageblks table structure
5). do the alter
6). import the data back in
Is there any other way todo this, keeping dbmail live? (i cant think of
any)..
Also, im using postfix/amavis, just wondering if there is some way to
delay the bounce back for that time (considering that dbmail wont be
accepting mail from amavis)?
Any thoughts appreciated.
Simon