Importing that much data is slow. Just copy the files for backup then
alter. Check to see if the number of rows match.
Simon wrote:
Hi...
On 11/15/05, Dominic Amann <[EMAIL PROTECTED]> wrote:
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;
But before i do this, im just wondering if there is anyone out there
who has done this before, and it there was any issues/TFYPs in doing
so?
We did that almost right away on installing dbmail: the initial data
import took us over the 4gb limit. No problems stemming from that.
OK.. What i might do is dump the table to a file, alter the table and
then re-import. Rather than doing the alter...
http://dev.mysql.com/doc/refman/4.1/en/full-table.html
On the notes above... some have had problems with data loss after not
doing a OPTIMIZE on the database before hand.
Any more comments from the list on this?
Thanks
Simon
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
