Re: Database back up again

[Chris Albertson <chrisalbertson90278@yahoo.com>]

Just do an "ls -l" in the directory where your databses file are
kept.  If one of them is close to 2.1GB that would be a big hint.

But MySQL is open source, you can read it.  Just look at where
they do the write on the index file and see id there is a
size check or if the code just bombs due to a lack of check.
"grep" should find it for you.

 

--- Fraser Farrell <fraser@trilobytes.com.au> wrote:
> Michael Sallman wrote:
> > On the database problem, does anyone know if MySQL has a size limit
> on
> > index files? I know there are size limits/defaults on the tables
> > themselves (which I ran into a while back with the observations
> table)
> > that can be tweaked, but I haven't found anything on the index
> files.
> 
> 
> Michael,
> 
> Don't know of any size limit specific to mySQL; but you might bump
> into 
> filesystem limits as the files grow? Some Linuxes have
> maximum-filesize 
> limits. Or if you have lots of files in a partition, you can run out
> of 
> inodes before you fill up the partition.
> 
> 
> cheers,
> 
> 
> -- 
> 
> Fraser Farrell
> 
> ----------------------------------
> http://astronomy.trilobytes.com.au
> ----------------------------------
> 
> 
> 


=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org
  KG6OMK


	
		
__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/