On 11/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote: > Sheeri, > > I think you've missed the point. The 4Gb limit is in mysql, not the > filesystem. > Mysql effectively doesn't limit tablesize, but the *default* pointer size > limits you to a max of about 4Gb in a MyISAM table. To have a larger table, > you > need to tell mysql that it needs to use a larger pointer for that table, > either > at table creation, or with an ALTER TABLE such as the one Simon is proposing > to > run. See the last half of > <http://dev.mysql.com/doc/refman/5.0/en/table-size.html> for more.
You're right, I did miss the point. Thanx for pointing this out; I wasn't sure why he was asking the question! -Sheeri -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]