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
johnny@stripped
p. 601.853.0211
c. 601.209.4985
-----Original Message-----
From: Dennis [mailto:dennis@stripped]
Sent: Wednesday, January 09, 2002 10:52 AM
To: mysql@stripped
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 <mysql-thread95833@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-johnny=mindbender.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
