Re: Database back up again

[Robert Creager <Robert_Creager@LogicalChaos.org>]

When grilled further on (Thu, 22 Jul 2004 19:54:36 -0500),
Michael Sallman <msallman@pro-ns.net> confessed:

> 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.
> It would probably make sense to break up my observations table (which is 
> now 8.9 gigs in size) into several smaller tables. But then I'd have to 
> re-code all the database queries. :-(
> 

Before you do that, think of switching to PostgreSQL.  No practical limits
you'll run into.  I know there are a few of us on the list (myself, Chris A.,
others?) that could assist you in converting.

I'm up to 6.3 gigs total for my ROB data db, with nary a problem.  I've not
nearly the number of observations you have, but have more data per observation.

Cheers,
Rob

-- 
 19:41:59 up 9 days, 21:35,  4 users,  load average: 2.12, 2.12, 2.04
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

PGP signature