List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:January 9 2002 4:26am
Subject:Re: 2 GB limit reached
View as plain text  
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?

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 6 days, processed 134,113,561 queries (249/sec. avg)
Thread
RE: 2 GB limit reachedDennis9 Jan
  • Re: 2 GB limit reachedRandy Katz9 Jan
  • Re: 2 GB limit reachedDan Nelson9 Jan
    • Re: 2 GB limit reachedDennis9 Jan
      • Re: 2 GB limit reachedJeremy Zawodny9 Jan
    • Suggestions - FullText ??Jon Shoberg10 Jan
      • Re: Suggestions - FullText ??Amir Aliabadi13 Jan
RE: 2 GB limit reachedEric Mayers9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedJeremy Zawodny9 Jan
      • Re: 2 GB limit reachedDennis9 Jan
        • RE: 2 GB limit reachedJohnny Withers9 Jan
          • Re: 2 GB limit reachedChris Wilson9 Jan
    • Re: 2 GB limit reachedChris Wilson9 Jan
      • Re: 2 GB limit reachedChris Cooper9 Jan
RE: 2 GB limit reachedQuentin Bennett9 Jan
  • RE: 2 GB limit reachedDennis9 Jan
    • Re: 2 GB limit reachedDan Nelson9 Jan