Another option depending on your needs would be the MERGE table type.
On Thu, 24 Jun 2004 22:21:58 +0100, Andrew Pattison
> The standard MySQL distribution comes with InnoDB support. You can also
> split tables into up to 255 blocks using MyISAMs RAID support.
> ----- Original Message -----
> From: "Rahul Sood" <rsdev20@stripped>
> To: <mysql@stripped>
> Sent: Thursday, June 24, 2004 10:14 PM
> Subject: table across multiple files
> > I'm installing mysql 4.0 on Linux x86
> > The application for which I'm using mysql requires support for splitting a
> table across multiple OS files. On the mysql website I read that this can be
> done with InnoDB storage engine. Does mysql 4.0 Standard version (which
> includes InnoDB) have this feature ?
> > Will it be necessary to get mysql 4.0 Max version ? The website said this
> version has some extra features such as Berkeley DBM and support for
> splitting a table across multiple files.
> > -Thanks,
> > Rahul Sood
> > rsdev20@stripped
> > ---------------------------------
> > Do you Yahoo!?
> > New and Improved Yahoo! Mail - 100MB free storage!
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1