Re: Database back up again

[Michael Sallman <msallman@pro-ns.net>]

Fraser and all,

The limit I ran up against previously was the 4GB MAX_ROWS limit 
described here:
http://dev.mysql.com/doc/mysql/en/Full_table.html

The file for the "observations" table is currently 9.12GB (and it's 
index file is 1.88GB)

Things seem to be loading fine now, so maybe it was just a case of the 
database getting corrupted.

Thanks to everyone for the suggestions.

Mike

Fraser Farrell 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,
> 
>