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
