Solved MariaDB - two separate databases on two different disks?

[amilis]

I use MariaDB on 14.2. I can’t figure out to have two separate databases on two different disks.
Any idea?

 

[covacat]

if the structure resembles mysql can't you just symlink the database dir to another place ?

 

[amilis]

I was thinking of some symlink… did some test before, but that didn’t went well..
Maybe that work? I will test again.
All databases is in /var/db/mysql.

 

[amilis]

Ha! This worked. Tnx.

- Make the folder - path/to/you_new_databse (you_new_databse = the database name you gonna create)
# chown -R mysql:mysql path/to/you_new_databse
- Make the database in MariaDB (as normal with the name - in this example: you_new_databse)
# mv /var/db/mysql/you_new_databse/db.opt path/to/you_new_databse/
# ln -s path/to/you_new_databse /var/db/mysql/