I’m regulating MySQL 5.1 as well as Windows 2008. No complaint formulating partitions upon the singular disk…but seems unfit to assign opposite mixed disks upon Windows regulating MySQL InnoDB setup. Tried manually formulating symlinks. Can’t find anything upon web. Is it not probable to assign the MySQL list opposite mixed disks upon Windows?
No, MySQL creates a new file for every database and not for every table.
You can create a new table on a new partition and use a view or enum to merge the two tables into a Pseudo Table, but performance is not great on large tables.