mysql 2gb table limit?

MySQL5 on win2003 - I'm new to mysql, and have a table that has reached

2gb in size and I can't put any more in. I am using innodb and have
set "large table support" to yes and have set max_rows to 5million and
avg_row_length to 6000. To no avail.

Help?

Re: mysql 2gb table limit?

Keith wrote:
> 2gb in size and I can't put any more in. I am using innodb

You can allocate more InnoDB tablespace files.

See http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.h tml

Regards,
Bill K.