As I said in my message (although I've still not had time to look further into this) this will not solve your problem completely. My 2.4.17 testbox will happily create >4gig flies - but as soon as my mysql myisam table reached 4gig I got a "Table full" error when trying to insert.
Going InnoDB is probably the best solution, from what I've seen so far - will mysql switch to make that the default table type at some point in the future? > Enable large file support: > > [root@xxx array0]# du -h bigfile > 2.9G bigfile > [root@xxx array0]# ls -al bigfile > -rw-rw-r-- 1 root root 3000000000 Jan 9 11:06 bigfile > [root@xxx array0]# uname -a > Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown > > > --------------------- > Johnny Withers > [EMAIL PROTECTED] > p. 601.853.0211 > c. 601.209.4985 > > -----Original Message----- > From: Dennis [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 09, 2002 10:52 AM > To: [EMAIL PROTECTED] > Subject: Re: 2 GB limit reached > > > At 11:26 PM 01/08/2002, you wrote: > >On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote: > > > At 07:07 PM 01/08/2002, you wrote: > > > >Dennis, > > > > > > > >You may want to look into using InnoDB tables. I believe InnoDB > tables > > > >are immune to the 2gb limit (which usually comes from the > filesystem). > > > >Also, InnoDB claims that the innodb tables are faster than MyISAM > tables > > > >in some cases. See www.innodb.com or > > > >http://www.mysql.com/doc/I/n/InnoDB_overview.html for further > detail. > > > > > > thanks, but that doesnt tell me how to recover THIS file....the > right > > > answer is "use a different OS", but thats out of my control here. > > > >Can you at least mysqldump the data out to a file? > > No, but that might be cumbersome with 4 million records. :-) > > db > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php> > -- Chris Wilson <[EMAIL PROTECTED]> http://www.wapmx.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
