Hi...

According to the MySQL 5.0 documentation, for setting up advanced
innodb, the following is stated:

An advanced my.cnf example. Suppose that you have a Linux computer with
2GB RAM and three 60GB hard disks at directory paths /, /dr2 and /dr3.
The following example shows possible configuration parameters in my.cnf
for InnoDB.

[mysqld]
# You can write your other MySQL server options here
# ...
innodb_data_home_dir =
#
# Data files must be able to hold your data and indexes
innodb_data_file_path =
/ibdata/ibdata1:2000M;/dr2/ibdata/ibdata2:2000M:autoextend

OK....let's assume that I have 2-tables, X and Y, and I want to create
them, BUT have X point to the ibdata1 path and Y to ibdata2. According
to the CREATE TABLE doc, the DATA DIRECTORY option only works for
MyISAM.

Anybody know how to do this using innodb?

Thanks,
Joe