Is it possible to set each database in MySQL to use a separate datadir?
I'm running a userdir development (sandbox) server and would like to put the MySQL data files for the database(s) for that user in their /home/<user>/mysql
directory. How would you do this?
- Linux Ubuntu Server 10.4
- MySQL Server version: 5.1.41
- Storage Engine type: InnoDB