Help! MySQL Error : The table 'attachment' is full

[mdreamer]

Hi,

I am getting an error form MySql:
MySQL Error : The table 'attachment' is full.
My users cannot upload any attachments, The table size is 4GB. I guess its sort of limitation from MySql and not vBulletin.
Do you know what setting do i need to change to increase the limit? Do you recommend "Switching Attachments from the Database to the File System"? If so why?

Thanks
Maayan Dreamer

[Jack12]

I'm unable to help on the database table issue, but I would recommend switching attachments from the database to the file system atleast until you get the mysql problem solved.

Why? Moving them to the file system will stop storing them in the database and therefore abolish any space restrictions (aside from that of your server storage limit, if any).

[mdreamer]

got it.. thanks!

[BirdOPrey5]

definitely move to the file system.... it really should be that way by default. Do avatars too while you're at it.