Hi, I had this too - in the documentation, although maybe not highlighted enough, there are instructions for overcoming 4G - you have to set MAX_ROWS for you table to a 'large' number to tell mysqld to use > 4 byte pointers for the file.
Regards Quentin -----Original Message----- From: Chris Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 7:07 a.m. To: Johnny Withers Cc: [EMAIL PROTECTED] Subject: Re: 2 GB limit reached 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. --------------------------------------------------------------------- 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
