Asif,
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, August 24, 2003 8:44 AM
Subject: split database
> I am running mysql 4.0.13 with innodb. I have data since 2000. I don't
> necessarily need
I am running mysql 4.0.13 with innodb. I have data since 2000. I don't
necessarily need to work with any data older than one year. Therefore I would
like to split the database. Then I like to backup data older than one year and
keep anything newer than one year and put it back to the same tables.
On Thu, 10 May 2001, roger westin wrote:
> > We have a database of size 10GB and its index is also
> > almost of the same size. Now we want this database in MYSQL.
> > Please let me know how we can slpit it across 3-4 hard
> > disks.We are using Linux 6.2
>
> Hi there,
> My self I have a machine
Hi!
If you use the InnoDB table type, you can configure the InnoDB
tablespace to consist of several 2 GB files which you can put
on different disks or in different directories. Look at the online
manual at www.mysql.com or www.innobase.fi on how to specify the
my.cnf parameters for InnoDB.
Regar
> We have a database of size 10GB and its index is also
> almost of the same size. Now we want this database in MYSQL.
> Please let me know how we can slpit it across 3-4 hard
> disks.We are using Linux 6.2
Hi there,
My self I have a machine runnig RH Linux 6.0 with a 70Gb database.
And it works
Hello
We have a database of size 10GB and its index is also
almost of the same size. Now we want this database in MYSQL.
Please let me know how we can slpit it across 3-4 hard
disks.We are using Linux 6.2
Kind Regards
Pawan
---
