Re: Move one database to another drive?

[Rick James]

Several issues; no simple answer.
* The logs (usually 2 of them) are for everyone; cannot split between databases.
* ibdata -- You can set innodb_file_per_table, but only applies to new databases.
* You could create a new table (with file per table), populate it from an existing database, then RENAME to put it in place.
* Even if you get some of the tables out of ibdata, you cannot easily recover the free space. (It will be free for InnoDB tables, but not free to the OS.)
* Symbolic links for the directories can be used to reposition a whole directory to another physical drive.
* Striping is more effective at spreading the load across drives. But that means dumping and reloading everything on disk.

Ponder those. See what you can come up with. Come back for more details if you like.