Hi.

I'm using MySql 5.

I want to spread the InnoDB tables on two different disks (one database).

I also want to control which table goes to which disk.

Nice if doable on both windows and linux.
It must work on linux since that is where my production DB are.

Is that doable, .. if so, can you show an example on how to configure that?

From the MySql.com site:
http://dev.mysql.com/doc/refman/5.0/...blespaces.html

"
Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore backups of single tables quickly without interrupting the use of the remaining InnoDB tables.
"

but I do not find any examples in the link above, on how to configure if I want to control which table goes to which disk.